I don't think I have ever, in 30 years, had a PC that I was playing "win the day" in any situation.
I've rolled high in a dramatic situation
once in approximately twenty years of gaming...
Once.
As a 2nd-level wizard in my very first 3E Greyhawk game, our party encountered a horde of goblins with a worg outside the ruins of Castle Greyhawk.
Our monk was the first to die. He had just hit 2nd level after being 19 xp short from the previous session, and the player had actually postponed his own birthday party that very day so he could make it to game. In the first round, a goblin with a javelin rolled a 20, and a 20 to confirm, and then a 19--at which point the DM saw fit to inform said player that we were using the instant death variant. That's right. The DM killed that poor character on the spot with a goblin javelin on the player's own birthday, with an optional rule that he had never brought up before then.
To make a long and depressing story short... We had four characters out of seven die in that battle, and I had already started thinking up a new character when the worg with 30-plus hit points remaining stared me down from 20 feet away. My wizard was out of spells and crossbowing at this point, so I figured... What the hell? I'll shoot him so that my character could at least go down fighting and then try to run.
I rolled a 20. I rolled another 20. The DM asked me to use a different die... I rolled a 19.
His party-killing worg dropped dead at my feet from a lucky shot, using the exact same optional rule and even the exact same rolls that he'd used with the first attack of the encounter.
That's the only time that I've ever actually rolled well in a dramatically appropriate situation, and possibly the only time that I've ever actually enjoyed rolling a die in and of itself. Good times.