> Here in SF it feels like no one wants public transport to get to them

I call BS on this. San Francisco residents just voted 2-1 to fund transportation more. See measure L in: https://sfelections.sfgov.org/measures

The only people who really don't want more, better transit live in Pac Heights and Sea Clif if you look at a precinct voter heatmap.