I usually play M&M, so characters rarely die in those games. Bad rolls are very common though. Sometimes the most fun and character development comes from having a lousy roll. These are the characters that have problems with the dice gods. Weird problems.
I've statted up characters meant to be skill monkeys who couldn't make a skill roll to save their lives. I've made blasters who couldn't hit the broad side of a barn with their nose touching it. I've made trackers who couldn't find their own toes. With GPS and a helpful blinking light to guide them.
They've always had plussees to even out those problems, like always making their saves or something. It was funny as hell.
So, what about the characters (doesn't matter which game) where the dice gods have other ideas on how the character plays out?
Sometimes, the game conspires to create great scenes.
Guardsman opens door. Techpriest wins initiative, and fires graviton gun.
The guardsman slammed the door open, and the cult leader's head snapped towards the noise with a panicked expression. A moment later, the techpriest triggered his graviton gun.
Cultist leader makes opposed Strength check against graviton gun, gets a simple failure and is pinned in place.
The cultist leader managed to draw a bolter pistol, but the weapon instantly became five times heavier, as did his entire body. He fell to one knee, the barrel of the pistol pointed downwards and scraping the floor; it was all he could do not to fall flat altogether.
Inquisitor is next; the character has the lowest Movement stat of the entire group, and has no way to get to the cultist and make an attack in the same round. Makes half-movement and draws weapon instead, planning to charge on the following round.
The inquisitor slowly walked into the room, a massive figure silhouetted against the bright light streaming in from the entrance. Only two pinpricks of light glinted off the eye-lenses of his black power armor. He drew an antique, ornate bolter as he spoke. The vox-caster gave his voice a low, rumbling feature that rattled the bones.
"Kneeling will not save you".
Cultist leader is next. Attempts Strength check again, and gets a simple failure again; he can act but cannot move. Given the situation, figures that dying beats getting captured and tortured for information.
Trembling with the effort, the man pushed against the ground with all his strength, first lifting his head, then straightening his quivering legs, and finally managing to lift the hand holding the bolter pistol.
"I... kneel... to... noone!"
Before any of the Agents of the Throne could stop him, he pointed the pistol at his own head and pulled the trigger; the mass-reactive round embedded itself into his brain and detonated fifty milliseconds later. The headless body immediately collapsed to the ground in the gravity field, blood being squeezed out of the ghastly wound and pooling rapidly.