Spec Ops: The Line. Sometimes, after the phenomenally long time it takes to reloads a checkpoint, it will do a long pause, then surprises you with sudden gunfire to the face.
Same thing with BF3.
Skyrim, on consoles, will sometimes either leave you looking at a blank screen for a while, or even worse, an actual loading screen that displays 'did-you-know?' after 'did-you-know?' and doesn't seem to be getting anywhere, leaving you to stare at an ugly werewolf while your mom wonders what's wrong with you.