The FAA has "field preemption" from Congress. Meaning any state or local law that conflicts with the FAA's stated purpose is automatically rendered moot and unenforceable. The FAAs mandate is the efficient operation of aircraft within the airspace.
So a law that bans a drone from using a massive speaker to violate a noise ordnance could be enforced, but a law against the operational noise of an aircraft could not. A city could ban a drone operator from flying over a crime scene low enough to disturb evidence, but could not ban a drone from passing over a crime scene.
Just buzzing someone's home by flying low (no speakers) is already pretty strong violation, can be criminal (harassing, stalking) per FAA. It's not new, been there since planes became popular.
If you are intending to harass or stalk someone, yes. Simply conducting normal flight operations (like drones making deliveries) is completely outside the realm of local laws.
This is one of the many reasons most delivery companies have gone with designs that don't touch down. If they land, they are subject to local laws.
So a law that bans a drone from using a massive speaker to violate a noise ordnance could be enforced, but a law against the operational noise of an aircraft could not. A city could ban a drone operator from flying over a crime scene low enough to disturb evidence, but could not ban a drone from passing over a crime scene.