if your looking for those point and click adventure games look for those classic Lucas arts stuff, like kupo said adventure games are pretty much dead.
ill list some good stuff for you:
Sam and Max
Full Throttle
Monkeys Island
Manic Mansion: Day of the Tenticle
Grim Fandango
oh, for the more recent stuff, check out Psychonauts, its an action adventure/platform game, its made by Tim Schaffer, dude who worked on those classic Lucas Arts stuff..