You can have affordable housing, good mass transit, and jobs. Pick two.
You double that and the infrastructure collapses. The tax base doesn't support large investments in transit to get a system built from nothing, and the roads and bridges aren't equipped to handle 2x the volume.