Varies, game to game for me.

Some games, I enjoy parts of the level up until the part I can't do.

After 50 times of retrying, I'm sick of it. I just want to be done with the level, not having to redo it.

If a game relies on you having to redo instead of checkpoints to extend its play value, its doing something wrong.