There are tons of these games being made by fans of adventure games today through something called Adventure Game Studio.
http://new.bigbluecup.com/games.php
A lot are short and some are bad, but most are excellent and innovative and cool. Some are even close to bettering their real life 80s and 90s commercial adventure games. They are currently working on another installment of the Indiana Jones franchise. The Stargate SG-1 game is very good.
I would however recommend the Chzo Mythos by Ben "Yatzee" Croshaw (the Zero Punctuation guy).
http://en.wikipedia.org/wiki/Chzo_Mythos
The 2nd game in the series is set in a sci-fi setting like Space Quest with some humor but mostly horror and it's damn frightening I tell you, these games that are done in nothing but low resolution 2D sprites!