I don't necessarily disagree, but OP's example is literally the worst example to pick.

There's a certain number of tiny keys for a certain number of doors and its very possible that parties don't get them all. Therefore is only logical and good design that the player has the option of backing out of opening a door.

Not saying that every single door or lever needs this confirmation window, just wanted to point out that there are situations were is warranted.