Barozi on 18 July 2010
Nuke in CoD4 was truly mindblowing
Endfight and the last cutscene of MGS4 were epic too
First Scarab fight in Halo 3 and of course the ending. Also the ending of Red Dead Redemption.
I'm sure there were more, but I need to think about them a bit longer.