I tried silent hill 4, but found it a bit slow and boring(to be honest i've played about half an hour, so maybe i'm wrong)
I like survival horror too(RE series is my favourite), but i don't find it scary.
Asylum level in Painkiller was rather close to scare me, but it was more disguisting than scary