I think he's largely lost his touch with horror. And I think it started when he copped out on the real possibilities of Pet Sematery and went for a generic monster/slasher vibe.
But some of his non-genre work, like "Rita Hayworth and The Shawshank Redemption", has been great.