> Every experience I've had with local government/HOAs has been a disappointing at best.

As far as I'm aware, most HOAs were imposed from above by the home builder rather than coming into existence via grassroots organization of the home owners.