Sierra's early catalog was basically a large collection of dead-man-walking situations. A key item for the endgame of Space Quest 1 stops being available 5 minutes into the game. Kings Quest II has a bridge that can breaks down every time you cross it, and you must do the right thing on every single crossing, as one superfluous crossing alone will end the game. Even as far as 1991 they were still making games where you could put yourself in an unwinnable scenario by missing an item hours before, sometimes in what you thought was a non-interactive cutscene!
Very few modern adventure games bring any of that back.
A lot of early adventure games were Cruel - requiring the user to replay the game over and over because they got something wrong was a cheap way to extend play time without having to add more content. Thankfully, most modern developers have realized that players hate having to do that.
Very few modern adventure games bring any of that back.