I had a great one in the original Max Payne. I opened a door causally and a little way down a narrow hallway was a dude with two Uzis. I completely froze for some reason and the dude saw me and emptied all his ammo at me. Unscathed, I moved my camera to look behind me - the wall was covered in bullet holes, apart from a vaguely Max Payne shaped section in the middle. I looked back around and nonchalantly shot the guy with my Desert Eagle and carried on my way.

I love lucky, dynamic movie moments like that.

In terms of more scripted stuff, everyone has rightly mentioned a bunch of Final Fantasy sections... I want to say: climbing that huge ladder in ​Metal Gear Solid 3