Even before the 2021 surge in home values, homes on city streets almost never saw as much growth in value (except for homes in the heart of metro areas where people will pay for location to work. On suburban city blocks, home values are often stagnant even in good markets)
One of the common problems I've heard of (not firsthand, so this may be apocryphal—but it wasn't just once that I heard it) is that buyers don't get to see the HOA agreement, or even know it exists, until after they've bought the property. (IIRC, the situations where the latter was the case were either buyers not reading their purchase contract closely enough, and thus missing the actual requirement to agree to the HOA, or neighborhoods where the HOA was not legally required, but if you didn't join it they'd gang up and make your life a living hell.)
I've heard the arguments in favor of them before, I just don't find them convincing.