I recall the original Poltergeist creeping me out back in the day, not sure how it would hold up watching it now.
I'll second that. I remember a babysitter showed it to me when I was young, pretty much as soon as it hit cable TV. If her goal was to keep me in check through fear, it certainly worked.
I liked Paranormal Activity, but I'm not sure I'd say it was scary.