As a guy who loves adventure games I'd say most of the good 90's adventure games still hold up pretty well (if you can bloody well play them...).
Never seems much love for those games on here, I don't understand why. Shooty games get very boring for me very fast. That isn't to say I hate them, I just can't play them as much as other people. I certainly wouldn't be arsed online with these things.
Edit: I forgot to mention Zelda: Link to the Past and Wind Waker. The latter as far as I'm concerned is still a beautiful looking game and both play very well.