I take BART to and from SFO all the time. But then I'm essentially always just with carry-on. Pretty much any public transit from airports (with the possible exception of busses explicitly set up for the purpose) aren't a great fit for travelers lugging a bunch of suitcases.