> No, the transportation problem in the US is that it is very large, and the majority of the cities are medium/small and public transport simply doesn't work in those sized cities (just not enough demand for continuous service).

Well, it does not work in bigger cities as well except NYC, Chicago and to some extent Boston. Also, OP talks about SF, which for it's size and population can have a good public transport system.