I am really a fan of Monkey Island and its sequels. It's fun with a bit of meta commentary sometimes and even though they do an "it was all a dream" a lot, it's great and you should play it.

Also don't know if it counts but don't touch anything is good as well. Not really adventure, because you stay in one room, and they made it 3d at some point, but the puzzles are great.