I mean all of Super Metroid is good with this; Ridley's theme in the first encounter on Ceres is really great, creates a panicky feeling as you're trying to protect the Baby
<object width="475" height="381">
<embed width="475" height="381" wmode="window" allowfullscreen="true" type="application/x-shockwave-flash" src="http://www.youtube.com/v/gXIdLLc8s-E&showsearch=0&fs=1&rel=0&autoplay=0&ap=%2526fmt%3D18"></embed></object>
and then Spore Spawn's music goes well with the eerie environment and slow combat for the battle. Kraid's music sounds like an elephant is stomping about!
<object width="475" height="381">
<embed width="475" height="381" wmode="window" allowfullscreen="true" type="application/x-shockwave-flash" src="http://www.youtube.com/v/11fNNN95_og&showsearch=0&fs=1&rel=0&autoplay=0&ap=%2526fmt%3D18"></embed></object>
also, the Dark Star Core battle music in M&L: Bowser's Inside Story is epic and amazing and perfect for the situation and hype.
<object width="475" height="381">
<embed width="475" height="381" wmode="window" allowfullscreen="true" type="application/x-shockwave-flash" src="http://www.youtube.com/v/ksk0wwG4wO0&showsearch=0&fs=1&rel=0&autoplay=0&ap=%2526fmt%3D18"></embed></object>
speaking of amazing, Shining the Holy Ark's boss music is great and one of my favourite game songs:
<object width="475" height="381">
<embed width="475" height="381" wmode="window" allowfullscreen="true" type="application/x-shockwave-flash" src="http://www.youtube.com/v/AorJL8gdPNw&showsearch=0&fs=1&rel=0&autoplay=0&ap=%2526fmt%3D18"></embed></object>
EDIT: appending Fluffy into the mix, mmmmmm~
<object width="475" height="381">
<embed width="475" height="381" wmode="window" allowfullscreen="true" type="application/x-shockwave-flash" src="http://www.youtube.com/v/yswgE4Owg0c&showsearch=0&fs=1&rel=0&autoplay=0&ap=%2526fmt%3D18"></embed></object>
____________________