I haven't played that many, but I can see why they went out of fashion. Outside the hands of genuinely funny and intelligent people, they tend to be kind of boring. I'd be interested to know of any non-comedic point and click games that actually manage to pull it off.

I like Grim Fandango. I've played some of Yahtzee Croshaw's adventure games, like 5 Days a Stranger, but I can't remember if they're any good. I tried playing Leisure Suit Larry once and it just wasn't very enjoyable.