I live in an unincorporated part of the county. I guess I got lucky because I wasn't thinking about this criteria when I bought the house. I have an HOA but they're not insane and I can deal with them.Most incorporated cities have code enforcement.
But paying people to drive around and look for minor violations just so they can call the cops - that's weird. It irritates the people who aren't doing anything wrong (just technically illegal) and diverts police resources to lower priority work.
I'm just trying to figure out the motivation. Do cities do this for the ticket revenue?