I think Anima from FFX freaked me out more than anything in a Final Fantasy game. But yeah, there are a few creepy scenes in FFVII too.