It's also very hard to find examples of long-term successful large-scale (town-scale) growth. So we can't just move substantial fractions of people from our largest cities to mid or small-sized cities in a matter of months or years (and get satisfactory results).
Undoubtedly NIMBY forces around the U.S. are partly to blame, but the Covid/WFH exodus is surely the more important factor at this point in time.
Applies to SF and SV too - and to the other citied
Having lived in one of those cities as a low-income resident, a medium-income resident, and now a high-income resident, I assure you that the high income residents do much less for these cities than any other group. And no, taxes do not make up for it.