I'm not much of a gamer... and now looking again into the video game market there really isn't anything that interests me. Either the marked completely misses the oskar demographic, or I simply don't know the good ones.

Anyway... looking for recommendations - no matter how old. I'm not a sucker for state-of-the-art graphics.

I'll start:

Quarantine
http://abandonia.com/en/games/146/Quarantine.html
When it comes to atmosphere this is one of the best games I ever played. You're a taxi driver in a prison town. After the outbreak of a virus that turns the murderous inmates into even more murderous inmates, the objective is to get the fuck out.
Soundtrack is made up of some australian 80's garage bands that really fits the setting. This was a lot of fun.

Silent Hill
http://www.youtube.com/watch?v=eds1ivwq1oc
I played the first part through, the second part half way, and the third part more recently.
I think the first part stands out - if you played it when it came out, I guess the impact was much greater. The scripted camera movements, the video filter that makes it look like an 8mm movie... it was nothing like any game I played before that.

I realize nobody likes to read through these, so I'll just list the rest

Leisure Suit Larry 7
Phantasmagoria
Zach Mc Kracken
Monkey's Island I, II
GTA III

I'm really missing the endtime atmosphere games that are not strictly first person shooters where you're frantically pressing the skip button at every cut scene. Generally I think a little more emphasis on the story wouldn't hurt most games.