Never been to SF so I can’t say how it is on BART but I’ve had good experiences in Chicago, DC, and Atlanta on public transit. However, back in the 80s, pre-Giuliani clean-up, I considered riding NYC transit and decided the odors emanating from the entry was not drawing me down there.
DC is pretty good. New York Subways have definitely improved since the early 90s.