Unless, of course, these games expect us to play our characters as idiots; I earnestly hope that's not the case.
Hey, I don’t spend 3 sessions with my players bashing their heads against a puzzle

And again, you’re doing the least interesting or charitable interpretation. You’ve been told multiple times that a competent character will not be facing a locked door in a vacuum and told “roll or fail.” If we get to that point, there’s something else there, or all the other work you did to get inside was the real obstacle and now we’re on to new more interesting things.
Most games that bake some version of “fail forward” in are not testing task resolution.