Consider what it'd take to get a transit system comparable to say Chicago's. (The two areas aren't that dissimilar in size and population. Chicagoland has 9.5 million people in 10,500 square miles; the Bay Area has 8 million people in 7,000 square miles.) Chicago has 500 miles of commuter rail plus 100 miles of rapid transit. San Francisco has 70 miles of light rail (Muni), plus ~180 miles of commuter rail (BART + Caltrain). And it's not clear that Muni even counts as a rapid transit line. Most of it isn't grade separated, so it's got an average speed of 8 miles per hour. (The D.C. Metro, a typical heavy-rail system, averages 33 miles per hour including stops.) The LRVs go about 5,000 miles between failures, versus 200,000 miles for a 7000-series D.C. Metro car.
So even to get to Chicago levels (where most people still drive!), you're talking about building a whole new subway system, plus building hundreds of miles of commuter rail across the Bay Area. It's a trillion dollar project, not a $100 billion project.
So what would it take to finance all that? Let's be charitable and say you can do it for $500 billion. California is currently issuing 25-year general obligation bonds at 5% for 25 year maturity. That's $35 billion per year in annual payments, divided by 2.6 million Bay Area households. Or about $13,500 per household per year.
If that sounds unaffordable, let’s hypothesize we just have “rich people” pay for it. The top 5% of households in the San Francisco metro area make an average of $600,000 per year. Applying that to the whole Bay Area, you’re looking at 130,000 households making $78 billion per year total. So the tax for transit would have to be the other 50% of income that California doesn’t already tax those folks.
Okay, surely billionaires have the money. Last year, US billionaires made $470 billion. So we are talking about less than a 10% billionaire’s tax, right? Well the Bay Area is just 3% of the country’s population. Hardly seems fair to give it such an outsized portion of confiscatory billionaire taxes. 3% of 470 is about $15 billion, not close to enough!
Oh, and here's the kicker. Everyone would pay for that new transit, but most people wouldn't be able to use it! In Chicago, only 12% of commuters take public transit, because the system, as extensive as it is, really only is good for getting people into downtown and back out. Even if San Francisco manages to double that, you're talking about everyone paying what would be in the rest of the country a mortgage on a house for a transit system 75% of people can't use.