This is a great question, and very relevant when it comes to Bay Area living.
The way I see it, the major pros of home-ownership while renting rooms (house-hacking) are 1) that you are accruing equity in a home with a very high value due to your location, 2) you reduce your housing expense, because you have to live somewhere anyway, and 3) your home will likely appreciate greatly over the course of your ownership of the property. Of course it could be called speculation to be relying on appreciation, and I certainly agree with that sentiment, however if you just look at the housing market's performance over time, it's very likely that over a 7-10 year period you can expect some amount of appreciation. Likely pretty sizable gains when all is said and done. If your goals are even more long-term, let's say thirty years, I don't think there are many people here that would make the argument that you wouldn't see appreciation, particularly in the SF Bay Area.
The cons in this case would be that 1) you are now a landlord and there are plenty of headaches that come along with that and 2) you are now responsible for any maintenance / cap ex (roof replacement, etc). You are definitely exposed to more risk as a home owner vs a renter. However if you intend to invest in real estate out of state anyway, even in the event that you choose to rent your personal residence, you will be exposed to these same risks. In my opinion it's better to dip your toes in with a property that you can see with your own eyes. It's just more real when it's tangible, right beneath your feet. Nothing is more valuable than everything you will learn about property management with that first rental.
Overall, I would recommend house hacking because I believe it's one of the most powerful wealth generators available to the average person. If you live, work, or intend to be in this area for an extended period of time, actually owning a property here is the best way to guarantee stability here. Rents, interest rates, and prices may rise or fall but I can tell you that when you have a paid-off property in one of the most affluent areas in the world, you will not regret it.
Let me know if you have any more questions or would like to chat real estate. Good luck and happy investing!