Bart closes at midnight and has four stops in the heart of SF. NY has an OK metro but if you want to go cross-town, better just walk. I've spent time in NYC and lived in SF, Zurich, Berlin, Prague and London. Europe destroys on this topic. A huge percentage of people in Europe, like myself, don't own cars simply because we don't have to.
Saying it's no contest is a huge exaggeration. I won't argue that BART/MUNI is better than other transit systems, but I still get around without a car.
That said, the fact that transit closes in London and Paris while New York doesn't is a major advantage. It's actually precisely the reason why I have been able to not take a taxi or have to walk home in the early morning. And in NYC, a lot of people don't own cars because they don't have to either.
And a lot of people in NYC don't have cars simply because they can't afford to park them, not because available mass transit makes them unnecessary.
I would not say the Bay Area has great public transit. It just has some public transit, which is more than you can say for a lot of California.
And you use the same old Oyster card as during the day. I assume it's just as cheap - 80p or a pound per ride? Cheap enough that I don't even keep track.
I agree with the GP - the overnight services outside of limited routes in NYC aren't flash, and most of the rest of the US metro areas are appalling.
Citation needed. 99.9% of the time I was lived in NY, I used public transit instead of taxis. London and France? Underground stops running close to one and so anytime I tried staying out late I needed to walk, take a night bus, or hail a cab (which is near impossible on a Friday night).