I don't know if I would qualify that as an adventure game as much as an interactive story. You really don't have to do much to make that game progress. Though I guess it's as close as it comes these days.

Also I forgot to mention the Shadowgate/Deja Vu/Uninvited trilogy. Loved those games.