SF can't build a public toilet without it turning into a national debacle. I wouldn't be holding my breath for city-wide infrastructure for biking improving anytime soon with the amount of grifting and NIMBYism in the city.
Uber and Cruise are the market's response to public infrastructure not meeting the population's needs due to politics, rent-seeking et al. The media love to disparage them, but as consumers they are exactly what many of us needed in this city.
A more civilized solution might be possible elsewhere, but not here in SF.
SFMTA is trying and literally making anti infrastructure, such as Valencia. I agree with your solution, but politically it's going nowhere. Self driving cars exist because our politicians are inept.