I really dislike horror, but some of my favourite movies could be described as horror movies.
Anyway, as for what's great about these movies, they actually tell something. They're not just here to make you afraid, they have a message and they beg you to listen.
Tl;dr: fear for fear's sake is...