Scariest I can remember recently was the bathroom scene in Eternal Darkness(Alex walks into the bathroom and sees herself dead in the bathtub, which is full of blood). I still don't know why, but it freaked me out.
Granted, I don't play survival horror games often, so my experience is limited.