I've had a few, the most recent ones would probably be the final cutscene in Brotherhood, I mean, who saw that coming!
and probably the death of Eli in Half life just as you thought everything was going to be OK (yes not very recent, but worth mentioning)