As you may notice, all the games recommended here are quite old.
The "Adventure games" genre has been quite dead for a while now. However there has been a few successful exceptions during the past.
Let me recommend a few adventure games that have been successful, and are slightly less old.
Runaway - A decent cell-shaded adventure game that had some level of success.
Psychonauts - an adventure / action game by Tim Schafer, the Genius behind Grim Fandago and the Monkey Island series.
Fahrenheit - Not funny, but is said to be the best adventure games in years.