the zelda theme is so great, in fact i like most of the nintendo core game tunes. sometimes it's hard to say "i really like the music" because you wouldn't listen to it while not playing the actual game, but it does so much to support the atmosphere. as is the case for me with starcraft and lots of other titles.
only one game has music that i keep listening to while not playing. it's "we love katamari" and the soundtrack is so fubar, i love it.
more variation here:
btw if you like music à la daft punk or justice here are some free electro remixes of zelda, mario and sonic tunes: http://theremixcompany.co.uk/?p=85
Castlevania: Symphony Of The Night had the best tracks ever. i haven't listened to everything else but i have trouble imagining any other soundtrack being better. The music is probably half of why I love the game so much.
Contra (the first one) and Megaman 2 had some great tracks, too.
Note that there are many different versions of the Outrun tunes out there. Sidology part 2 - Trinity
Incomplete table of contents:
00:00 Supremacy 04:00 R-Type 05:51 Skate or Die 06:15 ? 06:42 Super Mario Bros 06:44 ? 06:48 Legend of Zelda 06:49 ? 07:10 Last Ninja 2 (/Ocean Loader?) 07:59 Meteroid Prime 08:16 International Karate 10:21 Turrican 1 (/Loader?) 12:10 Meteroid Prime
Robert lists the songs in this forum post. Sidology part 3 - Apex Ultima
EPT
