BART SFO station is kind of special. Any trip from or end there is more expensive than a regular BART trip since they charge the so called airport fee. If you take BART and try to avoid SFO stop, then you should find BART fare generally acceptable, not that expensive. To Stanford, you can take Caltrain.