Anecdotally it sucks. The ADSL people generally have in SF is terribly slow. Even my moms internet in the Dutch country-side, 8 miles from the nearest city, with cows for neighbors on all four sides of the house, had faster internet than that.
For the Bay Area numbers: http://online.wsj.com/article/SB1000142405274870395970457545...