Dormouse
Doesn't know that mice use holes.
Posts: 2,517
Narnia does have the sort of "a hero is you" feel to it. I can dig it.
Personally I adore the Gormenghast series, Mervyn Peake's writing is so overwhelming and intricate, it's like reading a Gothic cathedral in braille.
Also the Star of the Guardians series by Margaret Weis is kind of amazing, it's a sort of Robespierre/Machiavelli-themed epic space opera.
I also heartily enjoy China Mieville (eg Perdido Street Station). He writes a gorgeously vulgar sort of fantasypunk noir with huge scope in his worldbuilding.
Charles DeLint can be amazing as well, he writes urban fantasy that gradually blends mythology that sort of lives on the fringe of city life. Someplace to be Flying is one of my favorite books of all time.
Haruki Murakami is sort of similar to DeLint in that his books start out very mundane, with uninspiring main characters, and the plot sort of drifts diagonally forward into increasing surreality almost before you (or the character) notices or can really second-guess it. His writing sets the sort of atmosphere like if you stay up super late at night and nobody's around, and the world just seems sort of unreal. Hardboiled Wonderland and the End of the World is the first one I read and it is very very good, but The Windup Bird Chronicles is one I keep going back to over and over as sort of a comfort-book.
Edit: I'm also ashamed that you didn't include Dune - Epic Nerdesert!
Edit2: I don't know about setting per se, but the Ender series (the old one at least, haven't read the new ones) get my vote for biggest emotional impact from any sci-fi/fantasy. Ender's Game especially usually makes me cry at least a few times throughout.
Also, I can kill you with my brain.