Our last house had an HOA with very loosely enforced CC&Rs. Our dues went to maintaining the common green space around the neighborhood. It was reasonable enough with no threat of fines.HOAs are *everywhere* here in AZ and listings often crow "NO HOA!" for the few places without them.
I currently live in a neighborhood without them, but it's going a bit downhill. I think if I feel I actually found a place where my fee went to a community pool or something, I'd be willing to check it out.
I think HOAs, like any other form of human government, works best when the people affected by it are involved. The overreach comes when one goes all in on power and the rest don't care enough to engage until it impacts them.