I grew up right by Ashburn, Virginia, which has the largest concentration of hyperscale data centers in the world. I rarely heard of organized opposition to them until they became a politically charged issue and associated with white collar layoffs.

I never once noticed significant noise from any of them - they are nearly all on the opposite side of a wide road from the nearest housing, and the road is louder than the data center. There is enough electric supply in the region that they almost never run the gas turbine generators.

As a way of growing the industrial tax base of an area, they are one of the least dirty ways to use industrially zoned land, though they don't produce as many long term jobs. There is a big data center construction and design industry in that region, and it did pull Amazon to open HQ2 nearby, but those are both first mover effects.