It was. Now (south of Market, west of Civic Center BART) it's high rises, towers and lots of houses that have been remodeled and mid-rises on the side streets. Around Twitter basically. All of which expensive - because well, it's at the center and walking distance of everything.
And on transit like I said, yes it's there. And could even be decent. Except it's not. I mean, it's non-existent in other places. But that doesn't make it anywhere near "nice" in San Francisco. Again depending on the neighborhoods that you try to drive through no doubt. Many people still don't have a good alternative and use it. When we have to.