Gabriel Knight: Sins of the Fathers is one of the last old school point and click adventures - and probably one of the best. You control Gabriel Knight, an unsuccessful writer and the owner of an antique and shabby bookstore who is investigating mysterious voodoo murders for a novel he's working on. In the course of the game you unveil what's behind the killings - as well as who Gabriel truly is. The absorbing story, the dark and gloomy atmosphere, the realistic characters as well as the logical and thoroughly thought through riddles ensure an intriguing gaming experience. At least that's what I've experienced

. Surely worth multiple playthorughs. It was abandonware once, but it's in ESA's iron grip now so getting it for free isn't possible anymore (unless you see Warez as an option).
Btw, don't expect Lucas Arts' type of humour. The game is much more serious than most Lucas Arts adventures. Still, there is humour to be found - if you consider dry and witty sarcasm as humour that is

.
I thoroughly enjoyed sequels as they both are high-quality adventure games - but none of them comes close to Sins of the Fathers. The Beast Within uses a full-motion-video engine and therefore real actors. It provides a great story, superb atmosphere but somehow I've never managed to finish it. Blood of the Sacred, Blood of the Damned is 3D, but still a true point and click adventure with a good story and great dialogs - but some of the riddles are over the top. Still, it's definitely worth a playthrough.