Are we speaking of films only? If not, I think the game "Slender: The eight pages" was pretty intense.

As for films, I'd say nothing was (or ever will be) as scary as Jaws, seen at the age of ten, just before the summer.