I mean its a bad example, but not the only example of obtuse puzzles in games preventing forward progress in game. Dead ends and not being able to finish if messed up a previous steps were real problems. This was a bigger issue when the internet wasn't available to help out. I like adventure games, but even still they can be difficult and frustrating (although maybe I'm not great at them)
Puzzle Dependency charts in game design help this (from Ron Gilbert/ Monkey Island etc...).