Haven't played too much FF or Zelda games so I have to go with the Secret of Monkey Island for purely emotional reasons. Here's an OC remix of one of the tunes in the game: http://djpretzel.web.aplus.net/songs/Secret_of_Monkey_Island_AmIEvil_OC_ReMix.mp3
Any links for your favourite tunes?
I think that non-grandiose music in the background works very well in many games like Metroid Prime and RE4, but they tend to be less appreciated.