I live in an HOA, and most areas in S.Fla look better if they are vs. the alternative. As far as 55+, the home that backs onto mine had never been an issue, until we had a rental family in there a couple of years ago.
Two kids under 8 - screamers, not cute playful kids, but one hitting the other, then the little one wailing, and a home-all-day Dad who would just come and yell at them a little, or turn down his music (which was also party-loud, every day..) to do so. Two loud dogs kept on the patio. And then he decided to take up wood work, which meant operating his table saw in his backyard for some reason, most afternoons, before the kids came home from school and it started all over again. Their only redeeming quality was they were quiet at night mostly.
But the family we've had since then? Quiet as can be.
Still, my next home will no have no rear neighbors of any age, and I'll be careful about side ones too. But the idea of never having to listen to anything like that again is quite appealing.