As others have said: Call Of Cthulhu: Dark Corners of the Earth.
Also, the Cradle level in Thief 3. It was the first time I've been so scared I couldn't think straight and forgot that you could attack the enemies. i was too afraid to go near them, and did the whole level without weapons. I like to think that's hardcore, but in reality I was bricking it totally.