Even in San Francisco, widely known for its public transit system, not having a car some of the time sucks. It's much more convenient to get around by car. That's why Uber and Zipcar are ultra popular here.
New York, sure. Everyone's heard of their subway.
The first time I'd ever heard of BART was when I visited briefly, and in doing so I learnt 2 things:
1) BART is pretty bad: noisy and a small network 2) Talking to people during my short stay made it pretty clear San-Fran and the bay area was considered 99% car territory, and traffic/congestion/commuting around SF was a significant problem commensurate with that fact.
Edit: understand this is a genuine question asked as a foreigner who has only formed an impression from short visits.
I couldn't see myself ever wanting to take that mode of transportation.