Isn't it generally better to have affordable housing than shockingly massively increasing home prices?

Clearly not, in the context of this discussion. No city is better off by eviscerated its tax base.

Only if anyone want to live there. Why would anyone want to purchase a house or live in a place how ever affordable it is, where a mob might burn their house down.

The way I read this is that the more desirable a city is to property devs, the lower the cost of housing, which seems true. Affordable housing = Less scarcity, less scarcity comes from building more