As much as I hate many stupid rules and seemingly unfair application of them, I do like that it mitigates against people that just don't give a shit about their property or the impact of their life choices on others.
You don’t need a potentially abusive and/or rent-seeking HOA for this. My locality controls for all of these potential issues through local ordinances.
I live in a "town" (Reston, VA) that has a notoriously strict HOA. But, it mostly applies to buying/selling and home additions. And it's very consistent. Each subdivision within Reston also has its own HOA that's run by the owners and in charge of regular community upkeep. It works out, as long as you perform due diligence up front and know what you're buying. I don't know anybody who would claim it was abusive or rent-seeking - just mildly annoying sometimes.
All the stories of people who bought in HOA areas and then got fined for having a work truck… I have little sympathy for them because that would’ve been in the HOA docs which were provided during contract negotiation.
The next step would be looking around the neighborhood to ensure that the rules are actually being fairly enforced. If the covenant say no work trucks, but there are work trucks parked at every third home then that’s indicative of a problem may or may not be an issue to you depending on your line of work, but it’s something to keep in line.
There are other things you can check as well. For example, ask for the HOA finances. Are they doing regular capital projects and do the budget seem reasonable? Do they have enough money in the bank for unforeseen capital expenses? Again not always a dealbreaker, but those are things you need to know and people frequently don’t bother asking about.