And because JDR says old-farts whatnot… I know one nonpointclick he didn't (dare) to play. FPS horror adventure is (Clive Barker's) Undying. I honestly despise FPS genre, and this game also has it's annoying part (a certain episode "above" tends to be boring as it's too long, the rest of the game is not like that), but I'm highly recommending it. Please, play it during the night, volume maxed and lights turned off. Do you dare?
I played Undying. Good game. In fact, I'd love to see that one show up at GOG, as it's not available in digital format anywhere right now afaik.
I liked Realms of the Haunting quite a bit as well. I enjoyed the first half of the game a lot more than the later parts. Imo, combat wasn't a strong point, and there was more of it in the latter stages.