I don’t have a specific link but I’d be surprised if the CityNerd channel on YouTube didn’t have a (recent) video on it. Just as a disclaimer: Even if you don’t agree with his politics, he does take care to explain his data set sources and methodology, so it’s likely a useful source for this sort of thing.
NYC is definitely the top dog. There was a recent ranking for metro areas ranked by walkability, bike-ability, public transit, and some other urban score, but divided by average rent price for a 1BR apartment. NYC still came out #1 despite the rather large denominator.
The BART is better than the DC metro in my experience. The DC Metro is great for commuters into metro center, but it shuts down too early, and is totally impractical for moving around the outside of the city/suburbs. The BART looks visibly in worse shape, but you can quite easily live car-free in SF
Jokes aside, I'd like to see a stack ranking of US public transit. I'd assume NYC and DC are top dogs, but I'm curious about other cities.