I enjoyed a lot of those movies, really didn't "scare" me, I just dug the vibe they put out. The movie that came the closest scaring me is the original Night of the Living Dead. I starting watching it and it caught me off guard.
As far as newer movies, Rob Zombie has a couple of good ones. After watching "House of 1000 Corpses" , when it was over I felt violated and had to take a shower.