As far as horror adventure games go I don't think any have really scared me. But back when my modem was working good I used to play a graphical mud in hardcore mode (limited number of lives then if you die and don't have any more your character gets erased) and I was afraid of dying, however the fear in that case was for completely different reasons.