Dark Seed had some creepy moments, even though the game is frustrating to play.
Some scary games I have played are Forbidden Siren 1 and 2, Eternal Darkness Sanity's Requiem, Resident Evil remake. I still consider Silent Hill 2 to be the pinnacle though of horror.
Some adventure games are scary, like Clock Tower (thinking back now, whoa, that was chilling) but with adventure games it's more unsettling than anything else. It's not a bad thing mind you, it's still scary
Oh the irony.