I paid 450 dollars up front for fiber for a year. It's really nice, but not available everywhere. If you want TV things are different, you have to go with the shitty cable service if so but it's no problem for me to forgo cable. As far as public transit, it's not great but it's pretty good within SF itself (which has a fairly extensive Muni system). If you want to travel further out, you need a car. It's getting better, but slowly, and some areas of the Bay are pretty resistant to change (silicon valley, especially).
At any rate, while I don't disagree that the city politics here tend to be very business friendly (some might even say conservative) I would characterize most of the city as socially liberal but extremely steeped in NiMBYism. The problem is the politics don't fall along a liberal/conservative dichotomy as some might want to generalize it to be. Rather, factionalism has made it difficult to build in a way that is really needed here -- as local interests protect their own extraordinarily well. That's a result of city politics being different than state or national politics. SF has a rich history of community activism and the housing crisis is the dark side of that.