I think it's gotta be one of the N64 Zelda's... everything is eerie when needed, upbeat when necessary, and foreboding when it should be. the music could not have been any better, in my opinion.

also, more recently, Super Mario Galaxy. Every time i start that up, i am reduced to shivers from the glory and awesomeness of the tunes