The only games i can think of that are actually scary are the Silent Hill games. Silent Hill 2 in particular is dreary and disturbing. Early Resident Evil games were good with jump scares, but The Silent Hill games were more psychologically disturbing and stayed with you way past putting the controller down.
Silent Hill 2