I'm also someone who isn't a huge fan of NSMB. I mean it looked great, it was fun but I bought it then thought it was totally a rental after beating it a couple of times.
It's like a prettied up, made easier old game. Just didn't do it for me.
On the other hand, and strangely, I would welcome a New Super Mario World a lot. I think this is because Super Mario World is my favorite 2D mario by far and I just cannot get enough of it.
So yes, even though I didn't like NSMB I would be first in line to get New Super Mario World on the DS.
I mean the game still looks great when I play it on the virtual console, it has the best worlds, yoshi, a good bowser fight, great dungeons, awesome ghost houses, some of the best music in a Mario game ever, loads and loads of levels and secrets, so many great things about this game.
The dungeon/fortress music in Super Mario World is my favorite Mario tune, even though there are much more known ones, that one I like the most easily.
I haven't bought any of the other Mario 2D games so far on the virtual console even though they were great for their time, this one is the most timeless one of all the side scrolling marios.