Let's not forget The Shining! I've heard claims that it's the favorite horror movie of people who don't like horror movies. I think that's because it fits in line with the movies you list in your first paragraph.