Anachronox ! It's a hilarious RPG / adventure. Just ignore the first hour of tedious gameplay it gets great after that. Also make sure you install the patch before starting to play :
http://www.planetanachronox.com/

For pure adventure play you can't go wrong with either The Longest Journey or Gabriel Knight: Holy Blood