I live in the bay area (north bay - marin county). We have SFH here and rental properties out-of-state. For what it is worth, here are somethings to consider.
-How long do you plan on residing in the area?
-What do you want for your exit strategy?
-What are the rental laws in the area you are considering purchasing (make sure you fully understand)?
As you've mentioned, it is very expensive to get into the real estate market here. If you're going to be in that area for 5-10 years, it may be worth looking into. Otherwise, renting may be the better option and buy outside CA. Personally, I'd avoid a SFH and only consider a tri or quad. Multiple units will always give you a better return than SFH.
Also, you can buy a multi-unit out of state for less than 20%. I did 2 years ago and only put 10% down. I bought it as my 'second home' took out a 7 year ARM at 3.25%. I made no mention of renting out the other unit...or both for that matter.
Make sure you understand the rental laws in that area. As you may know, SF is a heavily rent controlled city. Rent control is creeping outside of the city too. We live in San Rafael and there are loads of small multi-units around us. We have decided not to buy here because it is too expensive to buy-in AND rent control has been floated around city meetings. There is no rent control in place....yet. But, I do not want to be a landlord here if that does take place.