The sound comes from the string vibrating between the bridge and the FRET, not from it slapping or buzzing against the damn fretboard.
This is not true. The key of the note comes from that, NOT the sound.
The sound is a mixture of many, many factors. It starts with the body wood, the neck wood, screwed or glued in or neck through body, hardware, pickups, body mass, trem or hard tail, strings, the player himself etc etc etc.....
All the parts and materials are resonating with the vibrating strings, hence have influence on the sound (sometimes even the player is resonating, but that's for different reasons then, ha ha ha)
If they all work together perfectly and the production is high quality, then you have a good guitar.
That's why most people sell their cheap stuff after exchanging so and so many parts. You can't make cocoa out of sh**!
You can improve the thing by exchanging parts but after a while you still notice that it's cheap quality and you will get a good one and sell the junk (or keep it for melancholic reasons).
If it was just the vibrating strings making the sound, then there would be no need for all those different guitars in different price ranges on the market other than OPTICAL reasons, right??
And to answer your question: yes, maple is a little "woodier", brighter, has more attack while rosewood is warmer and smoother in tone.
I'm in a continuous fight within myself about which I like better. I prefer the look of maple, I like both sound characters depending on what I'm playing, then again I love the feel of rosewood (yes, there is a difference, too).
Considering the fact that I just bought 3 guitars with maple neck during the past 12 months I'd say that maple is slightly in pole position regarding my preference.
In acoustic guitars I DEFINITELY prefer rosewood necks. Maple mostly gets a little gritty on acoustics (my personal taste though), unless you buy a 2000 dollar high end acoustic. I've played one of those once and it sounded great. All others were too bright for my taste.
ONE BIG DISADVANTAGE WITH MAPLE NECKS: they need to be cleaned more often because due to the brighter color you see every dirt from meters away, while it doesn't matter if you're too lazy or simply forget to clean the rosewood fretboard regularly.