Exorcist was mainly scary because the first time it came out it was like the first of its kind (based on worRAB from my uncle who couldn't get to sleep after seeing it in the cinema) lol
I found it scary watching it on video as a young teen.
Of course the picture is dated, like many classics...