Mother Brain boss fight Super Metroid. Love that music very good emersion it adds

kid icarus (nes)
ff VI (opera scene rules)
ff VII
chrono trigger
mrtroid prime
secret of mana

my favorite game soundtracks

super metroid
secret of mana
donkey kong country 1+2
metroid prime
zelda: link to the past
mario bros 2
super mario world
wizards & warriors
goldeneye
perfect dark
sonic the hedgehog

OMG lol

i want to play that so bad after seeing that. that was awesome! ive known about that game for ages but ive never payed attention to it or seen gameplay.

anyhoo...on topic metroids music beats all

Zelda, mario, banjo, pokemon game boy and my number one favourite of all time ORCARINA OF TIME

For me definitely Castlevania games in general.  They almost always have excellent soundtracks.  I especially like Castlevania III and Symphony of the Night in that order.

Here are a few others (I tend to prefer older games with non-licensed music):

Secret of Mana

Yoshi's Island

Jet Grind Radio

Journey to Silius

Blaster Master

Batman

Contra

Streets of Rage 1-3

ActRaiser

SoulBlazer

Street Fighter II

Thunder Force III

Space Harrier

Super Metroid

Super Mario Bros. 3

Super Mario World 

Formerly LOZ: Ocarina of Time, but after playing and completing Metroid Prime 3, I've changed my mind.

Chrono Trigger!!!!

Metroid music (any game)

Metal Gear Solid

Halo main theme (whether you like the game or not, it's almost impossible to hate that theme)

Earthbound

Zelda (all games)

Final Fantasy music done by Nobuo Uematsu.

Halo has a great theme, one of the best in the industry.

And I'm a real sucker for the original Zelda theme. It's too bad that Nintendo doesn't use it in-game anymore.

Pokemon route music.

And of course Nintendo classic tracks.