I've been looking in the Oakland/Berkeley market for the past 4-6 months and have come across some deals that will cash flow positive. CoC is usually around 2-4% and cap is somewhere around 5-6%. Not the greatest, but that's me running the numbers and using a conventional loan and looking at vacant turnkey properties (properties that require relatively minor work). I've put in about a dozen offers or so, and have been outbid every time. That's probably because the properties I'm looking into are turnkey, making them super desirable for foreign cash investors - people who can set it and forget it.
Like you, I live in SF but want to invest in the East Bay. House-hacking would definitely be a good idea, but I believe if you evict and occupy a unit, you have to live there for 36 months (folks can correct me if I'm wrong). The other option is to buy properties that require work, fixing up, then renting out. You won't be able to get a conventional loan, and may require a 203K, but I'm starting to see that's the best option in this hot market.