Disco Elysium is probably the best implementation of the 'Fail Forward' ideology I've seen in a game - not 'Game Over' per se, because running out of Health or Morale will give you a game over, along with some nonstandard endings, but failing important story-related checks doesn't lock you out of the story, you're just encouraged to go explore other parts of the world - raising the skill associated with the check you failed opens it up again, and certain objects, thoughts, or interactions can also open them up again. In the same vein, failing noncritical checks can often lead to more interesting and/or advantageous outcomes than succeeding. As an example: