I've seen players die in successful blazes of glory, and I've seen players die in combat due to being outclassed or out gunned. All of them have been memorable in some way or another.
Players WON'T randomly die from pointless things unless they do something extremely foolish, like running around with several untreated Critical Injuries. But I hardly think that we should even consider removing the threat of death unless the players want it. I mean, if the players want their dudes to die for some reason, that's great, and can lead to great cinematic moments. But, that shouldn't be the only thing that can cause people to die. For example, I once had a barbarian kill a Fiend-Binder because he no longer thought that he was in control of his own soul, since he sold it to a contract devil right in front of them. He cut him down in one hit, and no one saw it coming. It was awesome. Alternatively, I had a krogan vanguard in my Mass Effect game biotic charge a reaper thresher maw and detonate a makeshift explosion that killed it, and him, in the process and saved their whole crew.
Similarly, in the movies, some guys die in blazes of glory, or because they want to, like Obi-Wan and Vader. But some don't. Jango Fett, Mace Windu, and Qui-Gon Jinn all die by being outclassed or outgunned. They died. Should they have survived just because their "PC" doesn't want them to? I think not.
I'm all for this post. There needs to be a balanced for both, sudden deaths and no-deaths are both enemies that can cheapen the narrative depending how it's implemented. Sudden deaths for either PCs or NPCs can certainly throw things in a loop of the story, while that's how things go, can certainly wash a session down the drain and dampen the enjoyment of the session. It really depends on the person or/and the game. In the 40k universe, I think it's awesome that I can die at any time and it really keeps me on my toes at any moment. In other games though, the focus isn't on sudden death and when it does happen, does feel like the fun ended there.
You can't have combat be friendly and toothless either. It's a saving grace on the narrative for sure, but to some players and GMs, it'll feel like a slog eventually. Some combats are meant to be road bumps, and sure, nobody wants to be killed by a road bump. I'm sure nobody wants to walk away laughing that they took on a legion of storm troopers and it was a complete joke of an encounter too. "I'll eventually win or survive, regardless of what I do" is not something I want players to think. Risk and daredevilry is encouraged and awesome, but abuse isn't. Setting a fuel depot on fire and running out (or trying to) in a blaze of glory is awesome, but setting a fuel depot on fire and staying in it (because you'll survive anyway) as an "I win" button on the encounter isn't. It's a fine line even I can't define.
But that may be beside the point on fudge and not fudging. Being a pin cushion is still silly regardless of that. I understand that you are rendered unconscious once you are rendered to zero health, which is a saving grace...but my argument with the system is that if it requires someone to actually walk up to you when you're down and blast you several times. Then, you might die. Unless you roll off and land in a fire/lava pit, even that's unlikely to happen in an active fire fight.