Disclaimer: I'm very anti-HOA. But I do think the case could be made for them in high-density housing like apartment buildings and condos.
Single family homes, though, no. When I was house shopping, I removed any that were part of an HOA from my search. I'm not saying there are no "good" HOAs, but I've heard too many horror stories, and good HOAs can become bad HOAs over time, and your only recourse is to move. No thanks.
I don't think they should be banned, per se, they definitely need reigned in as far as what they can mandate and an opt-out mechanism. I'm not sure how the latter would work if there's things like street maintenance, etc that's part of it, but I'm sure some solution could be found.