A perfect example of this already present in BG3 is when the priestess captures you and if you fail the TWO chances to free yourself the game "cheats" and sends you a new NPC (a dwarf woman) introducing herself as one of Raphael's lackeys and freeing you instead... This time remarking that "You will own him one" for the favor.
See? It's a failure, but it's one that opens a new narrative scenario instead of cutting you out interesting content. Hell, arguably it's MORE Interesting that just succeeding.
This was one of my favorite parts of BG3.
Failing checks and resolving myself to reload or enter an unavoidable combat, but instead I'm given cool new content. More of this please.