Dying can be cool.
Death has played an important roll in many great stories, including movies, TV shows, & video games.
My PCs aren't nameless & soulless pieces either. That doesn't mean that I shouldn't ever let them die. That doesn't mean that their death should always be left up to me. That doesn't mean that they should only die if it is "cool" or makes "a good story".
And frankly, I think "Gnigel was killed by the stirges because he was too stupid to think of any of the three simple ways he could have survived" may not be a great story, but it is generally a better story than "Gnigel miraculously survived the stirges even though he made some really stupid, fatal mistakes."
So, I get over the saddness & create another named PC & try to fill him with a unique soul.
(I'm not trying to say that you are wrong. Just sharing how things are both similar & different for me.)