If Paris, Tokyo, London, et al can have insanely good public transit, where a significant number of households don't own cars (50% of Londoners, 2/3 of Tokyoites, 2/3 of Parisians), then San Francisco can do the same.
The dream of amazing public transit in SF is possible.