Gazoinks: Myst? I'd say it works in that due to the "wandering around fooling with stuff until you figure out what's going on" feel.
Psyringe: That's only because Myst has no plot to speak of, and what doesn't exist, can't be damaged. ;) The effect is not limited to adventure games though. The same can happen with RPGs, even action games (battling a scary boss monster isn't really scary anymore when you're doing it for the 14th time because it kept killing you in the previous 13 attempts). It may be more pronounced in adventure games though, since those games at least _try_ to tell a story (which many action games don't bother with), and since the pacing is set completely by the player.
Myst had a story. It was mostly all what people would call "backstory" though.
How to tell a story in videogames is an interesting topic, and one I've been thinking about a lot lately. One thing I know for certain is that interaction is of great importance, given that it's the one thing that sets videogames apart from say CG movies. But how to integrate storytelling (something that's always been a set-in-concrete thing) into a medium that's as much a sport as it is an art?
One approach that Frictional Games goes for is eliminating what they call "black box mechanics," which basically means that they downplay the "game" part of videogames. I admit that it works fairly well in Amnesia, but I'm not really sold on it as the way for the industry to go. Here's their article on the subject if you're interested.
http://frictionalgames.blogspot.com/2012/08/the-self-presence-and-storytelling.html My thoughts, as well as some discussion about Amnesia's storytelling in the comments (EDIT: actually, I remembered wrong. The discussions about Amnesia's story took place in my Amnesia review :P)
.
http://videogamepotpourri.blogspot.com/2012/09/some-thoughts-on-self-presence-and.html I'm slowly struggling with my own article on storytelling, but it probably won't be done any time soon. Too many things to consider and ponder.
bazilisek: Scratches is bland, boring and mostly frustrating. So definitely not that.
Gazoinks: You could also try Dark Fall. It seems like it's better respected than Scratches, although I don''t know much about it.
bazilisek: Oh, yes. These games have a lot in common indeed. Namely being bland, boring and mostly frustrating.
Well, I liked Darkfall (at least the couple of hours I played of it) :P