The Drifter is a great narrative, but the puzzles are just OK.

Wadjet Eye developed and published games have quite a few great games. Blackwell series is awesome (I would've wanted a different ending for the series, but the games are great), Resonance, Unavowed, Primordia, Gemini Rue and Technobabylon are all great as well.

Kathy Rain is also good (haven't played the second one).

I doubt, though, that any are better than Curse of Monkey Island, Grim Fandango (which is arguably held back by its 3d graphics and controls) or The Longest Journey.