Any of the final battles in the 3D The Legend of Zelda games. Though my favorite is definitely the one from Twilight Princess. The music and everything is just perfect, plus the way "he" dies... THAT's manly!
Random game thought :
Why is Bionic Commando Rearmed 2 getting so much hate? We finally get a real game and they're not even satisfied... I'm starting to hate the gaming community so f****** much...