The chief difference between tabletop games and video games is this: tabletop games allow you anything but what the GM forbids, whereas video games forbid everything not allowed by the coding. And sometimes they get snippy about it.
• Halo veterans know you can hide behind the transparent map, in the cockpit, and last a long while killing space marines. In fact, if you’re smart you can shoot the soldiers and pick up their guns (IIRC), allowing for fully-automatic fire in your doomed, rebellious firefight.
• Star Trek: Elite Force does pretty much the same thing as Halo. You can kill the captain, whereupon endless waves of security troops spawn, and when you die you appear in the brig. Because the Federation is a bunch of wimps.
• The Deus Ex example isn’t really a good one. All the others are basically non-standard “Game Over” screens, whereas Deus Ex is just the inherent consequences of your own actions. Kinda like Fallout 3 (and other Bethesda RPG’s) that way.
• The missed one of the better examples in “All Ghillied Up”. Forget mad dogs, do the wrong thing at the wrong time and they send an ATTACK CHOPPER after you. Much more interesting, especially as you run for the anti-aircraft missile in the church… and die before getting it.
Come on, there HAS to be better examples out there. Two of my favorites are from one of the Ultima games. Attack Lord British, and he will annihilate you. Quickly.
Also, get the right reagents and learn the right spell, and you can kill everything in the world except you and Lord British. Oh, the game never ends, it’s just that there’s nothing for you to do but stand around in the throne room.
Everyone’s dead. No villains. No story. Nothing at all.