>Best character death doesn't have to be permanent.
I disagree. I've found very very few resurrections of characters to be satisfying. Maybe in Order of the Stick but it's explicitly a D&D comic. Or sparingly in an actual D&D campaign. But I've had it ruin stories. There was one I imagined for years just as a daydreaming head canon type of thing. It was a huge sci-fi war between transhumanist industrial cloning nightmare armies and thousands of other nations across a massive hollow planet. The first main characters (husband and wife) died, and their son Orion became main character. Later, he also died hurling himself and the BBEG into a pit of energy.

Years later his daughter Andromeda started having visions of him. She was taking combat stim drugs and borderline ODing because they enhanced her visions of enemy fleet movements. She also stayed a virgin and had weird ideas of banging her brother so their genetic gift would be even more powerful for the next generation. Not something to jerk off to, just part of her delusion and psychotic focus on increasing her psychic power. She also never knew her dad. So she followed the visions to an ancient nanite pool in a ruin tens of thousands of years old. Turns out the enemy had brought her fathers burnt corpse there with the hopes of resurrecting him as an assassin to use against her. They dropped Orion's 20 year old remains into the pool to resurrect him, Andromeda started fighting the elite enemy agents, and their leader has her pinned by the throat when Orion rises from the pool and, instead of killing Andromeda as electrodes brainwashed him to do, he beat the enemies to death barehanded and saved his daughter.

But afterward it felt hollow. His sacrifice felt cheap. I felt like I'd turned cheat codes on in a game and even if I turned them off again it didn't matter. It was tainted. I imagined less and less of the story after that and nowadays I barely think of it at all. And deep down I know it's because of that.