Unless you’re aiming for a specific path (when replaying, for example), I do find it’s much more satisfying when an RPG allows you to fail and then follow through with the consequences, without just hitting a hard stop or making you feel like you got a lesser experience as a result.
But it does rely on trust - I need to trust that a game is designed to do that before I commit to playing in a way where I don’t immediately reload a save when I fail a skill check.