I can vouch for SF. I work there, and take the train every day. The Bay Area has one of the best transit systems in the US.