I bought The Longest Journey because I saw a video of it on YouTube and it was really funny, it was in the recent Steam sales along with the sequel for around $5
I never thought it would be this good, though, it's so clever and the voice acting is absolutely fantastic. There's a ton of swearing but it never feels really forced, it just seems natural from the characters. Like this guy who happens to be a complete asshole:
I'm not normally into point and click adventures either but the story in this so gripping and the main character is really interesting and funny. It's pretty long too, I'm on chapter 3 out of 13 so far and I've played around 7 hours already!
It's from 2000 so it's a bit dated but it still plays great, however you're forced to play it at 640x480 which is a little lame but even blown up on my 24" monitor it doesn't look half bad to be honest. The Fraps recording in the video above didn't show the subtitles at the bottom for some reason. Weird.
Edit: and holy god damn if you like the Discworld books you will love this