http://tvtropes.org/pmwiki/pmwiki.php/UnwinnableByDesign/Sie...
And yeah it sucked.
Adventure games died for a while, but there are some good ones that have come out since the 90s. The Shivah captured a lot of the humor of the genre but with a distinctly Jewish flavor, and I found The Cat Lady to be far more captivating than Gabriel Knight or Phantasmagoria.
The artwork, music, sense of humor, and character building - including being able to import your character and keep building your skill points through each successive game in the series - made it really special. Truly the golden years of graphical RPGs, IMO.
Just a shame the series ended on a cliffhanger. There was supposed to be a Manhunter: London, but it was unfortunately canceled.