I was gonna say this one too. I reckon the others are all too young to remember just how good this was back in the day.Xenon II
http://uk.youtube.com/watch?v=E6jNosHmHG8
Can't believe that was almost 20 years ago!
Otherwise the various Zelda games have some awesome music.