Realms of the Haunting is on sale on Steam for 5 bucks right now, otherwise it's cheaper from GOG. Mix of first person shooter and point & click adventure, with cheesy horror FMV too.

A horror first-person shooter with tons of FMV that did NOT suck, mixing first-person shooting, point-and-click adventure, stealth, and other puzzles. FMVs actually t-a-k-e t-h-e-i-r t-i-m-e, which increases tension since you never know what and WHEN something will happen next and scare the heck out of you. And they use the game graphics as backdrops, so it feels cohesive. The main character reacts to the scares like you do (well, or you hope you would). He is very low-key, and gets used to the scary and weird things that happen, just as you do throughout the game, and faces them. Now, graphics look old even by 1996 standards -- cannot even look up properly, as in early Doom games.