This is a catch 22 because the way our cities are designed in America makes them unaffordable. American zoning in most cities prohibits the kind of dense mixed use development that makes low cost housing near work possible. We need to reform the zoning code in most cities and improve bike safety, walkability and public transportation to make headway.
Mid-sized USA cities tend to have half decent transit around their urban core (often woefully under-served especially in cities that don't have either trains/subways or else dedicated right-of-way for buses, but none-the-less serviceable).
However, the thing that mid-sized cities almost uniformly lack in the US is any form of regional commuter rail.
It seems clear that commuter rail is not a silver bullet. Housing density is probably what we really need.
I have more trouble seeing where the 500 seat office for a global enterprise should go on my city block. it seems like that sort of space would lead to a dead feeling at night when everyone goes home and the space sits empty.
Turns out when you don't need to allocate space for 500 cars around a building, you can build it in a single city block and coexist with other types of buildings. And you even get a rooftop with a view as a bonus.