I love scary books and movies but I can't think of any that physically scared me, especially not those which are quite impossible to be true (hauntings, etc.) I do remember being thrilled with books that grabbed me in a suspenseful way: I knew it was just a book but I could be gripped by the intensity and the mystery. One that comes to mind from my childhood is
Mystery of the Witches Bridge.