In my opinion, death of the MC actually destroys tension and pacing. Unless it is a tragic ending where perhaps you die in a grand heroic sacrifice or whatever, I would recommend against including too many. If you’re going to add them, be careful, and make sure they make sense for the tone and context of your story.
I actually believe that consequences shouldn’t come through death, because that just causes your audience to load a checkpoint, reversing all the consequences. If you’re going to make a consequence for failing a check or picking poor options, make it something meaningful. Perhaps in a Sci-Fi setting, the MC could lose a leg or arm and have it replaced by a prosthetic. Perhaps the MC loses an eye. Maybe a character that isn’t the MC is killed or otherwise injured.
I find that when I die in many IF books, my immediate reaction is “oh God damn it” followed by repeating the same death 9 times because I don’t know how to get past the section without dying. I actually had this issue with Zombie Exodus, my first ever COG book, as my dumb ass managed to repeatedly miss the very crucial thing on the oil tanker section that would make you survive, and had to look up a walkthrough.
TLDR: Forcing players to reload a checkpoint upon death can kill pacing and add to frustration, so be careful. Instead, maybe you could try having some other permanent consequence, such as a side character dying, the MC being maimed, etc. Though this may depend on the tone and author’s preference, of course.
Edit:
I agree. The possibility of death is almost necessary for certain books. Any kind of war novel where you play as just a soldier, one of many, practically needs the threat of death. Again, it really depends on the tone and genre.
And another major thing depends on how “snappy” the checkpoints are. Odds are, if there is no checkpoint… I’d probably quit, at least for the day. Checkpoints at the start of a chapter can be painful, too, if there are major decisions and long sequences before the actual death. I found Guns of Infinity handled death well, with checkpoints being directly before a battle so you can change your strategy and try again.