Car insurance is not that bad in California. I paid much more in Florida, same car so it was a few years older.
I worked with a guy in southern cal and he moved (back) to the SanFran area. He said he and his wife just used public transportation or rented Zip cars when they needed one.