Honestly, I think a lot of people have hit the big ones already. Not being much of a horror gamer myself, I would throw Metroid Fusion into the mix as a sci-fi horror game. There's also a horror jankfest called Martian Gothic, which is on PC & PS1, which is interesting for the multiple characters working together through the game - but if they meet, game over - it's by the same team as Dreamweb. There's also Deep Fear for Sega Saturn, which is basically Sega doing Resident Evil, but underwater - I've only ever seen LPs of it, but it looks like fun - I don't know if you need a translation patch. You could try another contemporary game, Fatal Frame, which I played a demo of, where you use a camera to fend off ghosts.