It honestly all depends on the game and the players. There's no real "right" answer for this. Some people want the possibility of death around every corner, while others want to engage in an epic story where PC deaths only occur when fitting to the narrative. As others have said, there are...