I call Song of Horror one of the most beautiful horror games I've played (the other is Bramble The Mountain King, lol). Obviously, it's subjective but I'd give the atmosphere and settings top marks. You could tell that the people who made it were architects, lol. The story is linear, as most video games are, but the enemy AI was designed in a way that each playthrough should have different scares. Except the first one that is scripted to teach the mechanics of that particular episode. There's also perma-death if you choose the harder difficulties and the scares in subsequent episodes should change further, depending on how many characters die. I've been meaning to finish playing it (still on episode 4) but I've been too busy and sidetracked with other things.Song of Horror, I have that sitting unopened on my backlog shelf, might have to give it a go.
Oh, another game I forgot to mention was Curse: The Eye of Isis. Though, I can't honestly call this a survival horror game even though it's listed as one. It was too goofy and dumb for that (you'll know what I mean if you give it a try) but I was fond of it because it was so goofy and dumb. The combat was terrible, though. It was reminiscent of Witcher 1's combat but with guns.