I'm a big fan of StrongTowns and this is the article that NotjustBikes used as a launching point for the specific episode of fuckcars porn that you posted: https://www.strongtowns.org/journal/2017-1-9-the-real-reason...
Fiscal soundness at the local level should not be a political issue, but IMO the progressive left has turned it into one by attacking anyone and everyone who isn't in rigid alignment with every element of their housing agenda, which includes some pretty radical (and largely undesirable) changes for most Americans. And then of course when people balk at these undesirable changes, they're called racist, selfish, or both.
I don't agree that you can really claim one part of town is subsidizing others based on the analysis from firms like urban3. Sure, if you stuck 10 businesses on a plot of land where only 1 exists now and those businesses all thrive, tax revenue would be higher for that plot of land. Is there demand for 10 more businesses in your city or town, times every drive thru fast food joint or Starbucks? Is it actually a problem that businesses are paying more in taxes than they consume in services, which lets residents pay less than they consume? Would those businesses be there if their owners couldn't live in the type of housing they wanted in the city? There are so many intertwined issues that seem impossible to decouple to me, in addition to the obvious issue that the school system is the primary consumer of tax revenue in almost every area and the taxes paid by parents don't come close to covering that expense.
It's also not a coincidence that they picked an economically depressed area with a fairly high crime rate for this analysis. If they looked at a city with residents who made the median household income for the US, or even above it, I suspect you'd see a very different picture (though the larger point is still worth considering and largely valid).
I do agree completely that the federal and state governments are just setting these places up for failure (and future rounds of external funding), but I don't see YIMBYs talking about that. They just seem to be angry that people are living more comfortably than they would like in lower density housing instead of embracing the urban lifestyle they are so passionate about, and want to force everyone to align to their vision not for fiscal stability, but for ideological reasons.