Yes, it can be great when done right. But it's absolutely terrible when it's not done right. The vast majority of them are not done right. They are mostly done on the cheap with no attention to detail or craftsmanship, it is just an easy way to throw in lazy jump scares.

Look at the Paranormal Activity films. The first one is a masterclass of slow burn, effective horror. The rest are increasingly forgettable trash.