Good mentions all-around. I'll add one that wouldn't ever really be called scariest ever, but interesting regardless. Horror RPG that's scheduled for release sometime next year on PSP, Corpse Party.
http://www.xseedgames.com/something/index.php
http://www.xseedgames.com/something/index.php