Yea, that doesn't work for me. I'm more like Kirk. There is no such thing as a 'no win scenario'. Even if I have to cheat to get it.
To me, it cheapens the death to know it's inevitable and there was nothing I could do to avoid it.
I'm reminded of a line from Heavy Metal *said with casual disregard* "He dies, she dies...everyone dies."
It largely depends, but in video games in order for deaths to be something I have the power over, it needs to be handled incredibly carefully, otherwise it comes off as more nonsensical then anything else(this happens a lot in movies and books I should add). Game of thrones, to me, handles death the best I have seen, because all the deaths make sense, to me, even if I dont like them.
So sure, if I'm in control of the death, that is sometimes fine too, but I rarely have experienced such a thing where the death didnt feel like a..."game" death, where it having very little to do with the story line. Deaths I have no control over though are amazing. I remember with Leandra the forums everywhere asking is there is anything they could do to prevent the outcome, going back and redoing everything. To me that is a GREAT thing ot achieve, it showed that people are willing to go to great lengths(even ones they might disagree with, blood magic) to try and prevent a death. Sometimes the best way to force introspection in books, movies, games in terms of death is forcing you to experience the loss, but giving you different...events that lead to the same outcome.
I like it when it forces you to look at what you are willing to do, to try and get what you want when it matters most to you.