A lot of the greats have already been mentioned by others, but Myst (1993) and Riven (1997) deserve to be up there.

Not only for the immersive worlds you got to experience through masterfully crafted imagery, sound and music, but also combined they held the record for best selling game series until they were surpassed by The Sims.