Many of my neighbors also list on Airbnb. But we are all either on-site or home-share hosts, it's a quiet countryside area that we advertise as such, so there are no issues and no complaints from neighbrs who don't host. I only rent to one guest at a time, and they don't even drive here. No one would even know they are here unless they were watching the place constantly to monitor who was walking down the road to my place, and then they wouldn't even know if they were just friends of mine who dropped by or came to visit.
The one time there was an issue was when one neighbor rented out their house while they were out-of-town for 6 months to a young woman who misrepresented her intentions, saying she and her friend were going to live there, then turned around and listed it on Airbnb as a whole house rental. There was a huge noisy party with at least a dozen people and cars coming and going. That got shut down real quick. Even though many of us are Airbnb hosts ourselves, we don't tolerate that sort of disruption to the peace here.
An entire house rental is of absolutely no benefit to neighbors, even if the guests aren't party animals. People don't want a constant parade of strangers coming and going in their neighborhoods to occupy a house.