In Dark Souls walking into Gwyn's chamber where the piano music kicks in and the old hollowed lord charges at you.

The 3rd to last mission in Ace Combat Zero has you flying through a dark, rainy old battlefield area where you do nothing else but fight a 2vs8 dog fight against an enemy boss squadron. It's so hectic and the music as well as radio chatter make it real epic.