All the neck woods are great, and sound different from one another, but of course it all depends what the neck is attached to!
Example: a maple neck and ebony board are a bright and articulate combination on a solid body, but on a big ole L-5 CES like Wes Montgomery played, it's plenty warm sounding and not jangly.
And then there's the whole question of set neck versus bolt-on, and there are more differences to talk about. My feeling is that even on a solid body, all the neck woods work fine for whatever I play, and it's really a question of finding a personal voice, whatever that may be. I tend to prefer mahogany necks with a solid body, but my acoustic is all maple, and I love its sound.
I've had a few with rosewood necks, and they sound warm and great, too.