Quote from @Jacob Stevenson:
I feel like every STR I own came with opposition. For that reason I don't completely agree with the idea of only go where welcome. Even the long-term rentals I own people in the neighborhood have told me they don't want rentals on the block. People don't like the idea and have the mindset that they would always prefer a homeowner in the house.
Proper management and vetting of tenants can win people over but I think it's also human nature they'll never agree that it's better than what they thought should happen.
Just to clarify,
Opposition by a neighbor is not nearly as big an issue as opposition by an HOA. I invest in Florida and live in Georgia. In both of those states HOA's have a lot of power. If you go around the HOA rules, and they want to pick a fight, they can fine you and if you don't pay they can foreclose on your property. That's what I mean by not wanting a fight.
If a neighbor opposes you, they will stop complaining as long as you are a good neighbor (and they aren't crazy). In those cases just follow the law.
My fear in pushing it too far is the $20,000 it can cost to just show up in court with a lawyer and fight a single issue. Usually the HOA has more money than you do.