It also doesn’t get you around the city (and isn’t near any significant number of schools).

It is good for getting in and out, assuming you already have a way of getting to the Caltrain station which isn’t exactly in the center of the city.

Eventually Caltrain will go to Salesforce tower

That is the baseline, not a high bar.