It definitely depends on the player. I think most players like some risk.The question is: Do players actually want this risk?
At one point, I offered to take PC death completely off the table for one of my groups, and they didn't want that. That's when we came up with the death-vs-permadeath compromise (i.e., PCs can die but if the player isn't ready to retire the character, we'll find a way to make it not-permanent).