The biggest transit things actually taking place locally are CA HSR(which is happening, and Caltrain is currently shovels-in-ground electrifying track which will improve speeds and frequencies in the next year or two) and the continued expansion of the ferry system, which was displaced by the Bay Bridge and BART and then rediscovered after 1989 as emergency transport following the Loma Prieta earthquake. WETA, the "Water Emergency Transportation Authority" has some exciting projects that they are able to deploy relatively quickly and cheaply.
The X-factor is the robotaxis. They are currently "just" taxi, and priced like one, but people are using them to get around the city successfully. Cutting down the price and scaling access, which Cruise is set on doing, will have dramatic effects on transport as a whole, and not necessarily in a bad way, because the profitability of a robotaxi system, unlike private auto sales and cab drivers, converges with transit's goals - energy use, vehicle size, availability, etc.
While SF city and county is now actively fighting against them, the potential is there for every city where they're being deployed.