Agreed. I am also carless, but I wouldn't want to move to San Fran. as it's much too expensive.
You should for sure consider other places in Cali. like San Diego, which has perfectly good public transit, but I would also consider the DC area, Austin, Chapel Hill (free and frequent bus service), etc.