Already said, but Valiant Hearts' ending was absolutely brutal.
Another few that always hit close to home for me is the 'victory timer' in DEFCON ( I count it as a scene because it's guaranteed to happen ), the finale to the game WARSAW and the "by the manual speech" Edwards gives in Battlefield...