I would avoid it in games where death is permanent unless I was dropping them and felt death was the best way to go... but that would have to be a pretty well thought-out plot.
I am a big fan of games that have nasty punishments for letting your characters die, though. It pretty much assures that people will only kill their characters for important reasons rather than stirring up-