https://psteamproxy.yuanyoumao.com/app/214490/Alien_Isolation/

Nope, these days someone will immediately want to censor or ban it.

Horror isn't my thing so I don't have any scary ones to offer, but here are some dark hidden gems (IMO) to maybe consider:

Buckshot Roulette
Ravenous Devils
Paint the Town Red
Half Sword

Condemned

I want to play RE Village but…

Doom 3 always gives me the creeps too.

I know you said you don’t care for the mainstream, but there it is.

Classic:

https://psteamproxy.yuanyoumao.com/app/57300/Amnesia_The_Dark_Descent/

Amnesia the bunker i must admit it was one of the scariest experiences if you play in evenings with headphones, Outlast games (all games) , Outlast Trials not only scary but multiplayer to , real gem :)