Melbourne Metro, for example, has roughly the same amount of weekday riders as BART, 415,000 vs 446,000 respectively, with nearly 5 times(!) the amount of track, at 540mi vs 112mi.
This is, of course, excluding light rail services -- another 150mi of track in Melbourne with some 1,700 stops, and non-Metro heavy-rail services to the other nearby commuter hub cities like Geelong and Ballarat.
Berlin is, from my knowledge, more similar to Melbourne than to SF in this respect.
But y'know what the funny thing is? Everyone in Melbourne hates the bus service. Makes me wonder about what they think about buses in Berlin.
The price of places under ten minutes from a BART station further out were sharply different to further out in the same area too. You could shave some time off by cycling but then you're the guy with a bike on the packed train.
Seem to recall 20+ minute waits for trains in Berkeley on weekends too (it'd be handy if they let you know this somewhere in the station before you pass the ticket point, but that's another thing), with a transfer required to get into SF?
SF is far from the worst area for public transport, but it'd never come near my best.
This is just crazy. Compared to the cost of new track some additional rolling stock should be almost insignificant. You couldn't come up with a better example of penny wise, pound foolish...
Then I moved to Berkeley. Commute in is every 15 minutes, 50/50 I have to take a transfer on the way in. Commute home is a nightmare: BART has a carriage shortage so they try to shave off cars from longer routes (such as the Richmond line). This means things get really crowded on occasion, and there's a point where a car being crowded begets more crowding, as it takes longer and longer to offboard/onboard people and therefore each subsequent stop has more people to cram on. A majority of the time on my way home when I get a transfer (as there seems to be a Richmond train from SF only for an hour span at the peak of rush hour), the trains are almost an entire cycle late, meaning I've got another 15 minute wait to see two trains come through one after the other.
The point of this is: the problems you raise with busses are also with trains/BART. Some of them are even worse for BART: you have to steeply limit the service area because putting down tracks is stupendously expensive.