Here in the SF area we have Caltrain, but it runs infrequently and is very slow. Level crossings mean that it's also noisy. I would take it more if it were free (right now it's still cheaper to drive my 19.6 mpg 300 HP fun-car), but I wouldn't take it a lot more. If, however, it ran so often that I didn't need to think about the schedule, and were faster (by eliminating stops, possibly by color-coding trains), that would be a different story.
The buses are ludicrously slow and nobody knows when or where they're stopping or going. Few people take them at all. Nobody in my socio-economic group. They're just too stupid.
BART has a better schedule, but doesn't have a useful connection to Caltrain. It doesn't connect around the south side of the bay.
No system makes easy, direct connections to the major airports like you expect in major metropolitan areas. They all require at least one connection via a janky, slow, annoying shuttle bus. At worst they require several hops between various forms of transit. SFO is especially bad since they charge obnoxious fees for shared ride vans, even to off-site parking, and then make it nearly impossible to walk there from anywhere reasonable. They have no interest in improving access to their airport.
tl;dr: I'd take one form more, but not a lot more. I'd take public transit a lot at any cost that's less than driving so long as it's time-competitive with my alternatives. Right now nothing competes with my bicycle for less-than-fifteen-mile trips.