Hi Danny,
I'm a fellow investor here in the Los Angeles market and just thought I'd share my thoughts and my current strategy. I recently sold my primary residence after substantial appreciation at a premium due to my property having multi family zoning in a fast growing part of LA. Similar to the Bay Area, Los Angeles has started to increase dramatically in price. What I did next was run through my possible scenarios similar to yourself.
1) House hack, use the proceeds to put 40%down on a triplex or fourplex but in a C- type of area (sold property was in a B neighborhood), and have a larger amount to invest OOS to build a larger income portfolio. This small multi family would still be a negative cash flow in my area but a lot less than buying a SFH on its own. A 5 cap in my area is considered a good deal so it's really hard to cash flow in my market.
2) House hack, Buy a duplex in an A or B neighborhood with about 40% down and invest a smaller amount OOS to build some cash flow to maximize proceeds.
3) Rent and invest a majority of the proceeds out of state and build a large amount of cash flow.
I went with option 2 and ended up buying a light fixer upper in an A neighborhood with a newly built fully permitted 1bd/ba ADU that I'll rent out in the back. Now it really comes down to your comfortability but I felt buying in a quality neighborhood with some rental income to offset my mortgage and expenses was perfect. I also have a lot of equity in it so I could always use my equity line to juice up the funds I invest OOS. I also have the option to BRRRR it and get another property.
I didn't like option 1 because the CA eviction moratorium was a bit of a concern for me. LA is actually even worse than the state because I can't evict for Covid reasons 1 year after the emergency declaration ends. I just didn't like the risk that brought with having several units to cover expenses for over several months. I know some investors that have tenants that haven't paid for several months and they can't even start the eviction process because of the moratorium. I also wasn't crazy about moving my family to a C- neighborhood.
I almost went with Option 3 but being able to buy a light fixer and having equity right away in a good neighborhood is really rare in my area so I grabbed the chance right away.
I think the biggest issue you may have house hacking in northern California is finding a deal where the negative cash flow makes sense for you because prices are pretty up there. The only reason it worked for me was because I was able to roll money from a property I sold and I found the right deal that made sense for me. I'm not as familiar with the Sacramento market but if it's anything close to SF I'm pretty sure it may still be expensive so the deal that makes sense for you is key.