During my first playthrough of Fallout 3, I did find the metro tunnels and other such places to be somewhat horror, though it does lose the horror after you've played through the game a few times, or have enough supplies to make survival easy.
I highly reccomend some of the more horror-esque...