Legend of Zelda Ocarino of time and Majoras Mask, Halo and Halo 2s soundtracks. The legend of Dragoon (EPIC music), Megaman X6 (Boss fight music and certain level music is amazing), Guitar Hero 2s entire set list, Duke Nukem 3D's level music. Destinys Soundtrack (My favorites being Crotas End Raid Boss Music and the Secret Level in Lost to Light(Black Spindle)) , Castlevania SOTN entire soundtrack, Sonic the hedgehogs 1-2-3 and Knuckles (the originals) music, my Favorite being sonic 3. FF7s music of course, I would say sky rim but Fallout Pip Boy Music has it beat by miles. Bioshock 1 and 2 have some pretty fantastical music aswell very creepy and moody.
And I'm sure my list is far from incomplete, but that's off the top of my head.