I loved M.Night's "The Village" , that has so far been my favorite horror movie. The monster in it creeped me out! and that the story had a mysterious twist at the end.
The scariest one I think I have ever saw was "The Exorcist". I can't watch one anymore.