For me:
Uncharted 2: Fighting in the collapsing building
Call of Duty 4: The nuke going off and the aftermath
Mass Effect 1 & 2: The segments mentioned in the OP
Dragon Age: Origins: The final battles in Denerim
Half-Life 2: Ep2: The ending
FFXIII: Cut scene upon entering Gran Pulse
MGS4: ending. Really only works if you've followed the series fully though.