The ideal transport is be a bicycle, or an e-bike for cities with hills. The problem is that bike lanes are still not great. I bike commuted in SF for years. Bikes are ideal "last mile" transport too, for long commutes trains with bike carriages can be added in. Numerous cities in Europe show this works very well.
Having said that, it's an ideal which I fear is probably far from reachable for most people given the way cities have been built, and infrastructure priorities in the US do not favour bikes.
I love biking and am excited by the possibility of the roads having more attentive and courteous Waymo cars and fewer speeding and drunk human drivers. (A man on bike was killed by a drunk speeding driver 24 hours ago 300 feet from my home.)