Totally depends on the guitar and its purpose. I generally prefer the look of Maple on most guitars.
Strats and Teles in particular pretty much require Maple as far as I'm concerned. In fact any guitar with a more radial fretboard (Jag, Mustang, Jazz master etc) are in that same category.
Guitars that are more "lead guitar" oriented, shred machines, Les Pauls, etc pretty much call for Rosewood.
The exception on the later would be some of the gawdy 80s shred machines like the Jackson/Charvelle types etc that somehow pulled off the Maple thing.