Still Life was very sadistic, from the way the victims were killed and the inclusion of the cookie puzzle
I agree with Zork Nemisis, very dark, and not at all like the old Zorks.
The best horror games I've played were first person shooters like Realms of the Haunting, Undying and System Shock 2.