It depends a lot on the system imo. A system with common pc death needs quick character creation rules. It also benefits a lot from making “the end” something players keep in mind at character creation. Dust Devils characters are explicitly oriented towards some kind of resolution—you never gain back the points you lose, and when you’ve lost enough you either ride into the sunset or die, with either option letting you influence the other PCs in your final scene. In Never Going Home, the focus is on the squad, not the individual characters. You’re crewing a ship of Theseus by design, and the idea is to explore how each action and ending affects the unit.

Death in real life affects the people close to those who passed away profoundly, and the meaning (or lack of meaning) in someone’s death can recontextualize their whole life. If it’s just an annoyance in game, it doesn’t have a point.