What I mean by this, is instead of when you fail and are met with a game over, the game finds some way to keep it going. Instead of being forced to reset to a previous save or an autosave checkpoint, the game's story continues in an interesting path. Are there any games like this?

Asking because in IRL TTRPG's, a lot of DM's will find reasons to keep the story going, no matter how ludicrous because I mean.. that's why you're there. Do games do this? What are some that do?