I think Mordheim did it decently well. Without the threat of permanent injuries and death it wouldn't be the same grimdark experience, it'd just be a meaningless grind where you bring back either more money or less. It works great at the beginning of the game where buying new units is expensive, you don't know any maps and they feel genuinely dangerous and your builds aren't online yet. Falls off quite a bit once you've got the hang of it, but still serves as a mechanic that painfully reminds you not to get too reckless just because your party is working much better than in the beginning.>What would it take for you to not reload the save when your star character dies?
Iron man mode & save upon character death. The best games I've ever played were those in iron man mode where I rage quit and came back the next day to fix it. It just feel much better to overcome something than just to win all the time and without iron man, I'd just reload in the heat of the moment.