Also from the Bay Area. I have been investing since the last recession. I snatched a few amazing foreclosures between 2009 -2012. I held only 3 of them until 2020. During those 4 or 5 years I constantly bought and sold properties from auctions and banks for quick flips. Had I kept those properties, I would have retired a few years ago. My finances are good, but I am still working in corporate, granted it's a well-paid tech job. Now it's more of intellectual challenges and wanting to scale up on different kinds of real estate. I also don't enjoy remodels and managing properties anymore after years of doing that. After selling some of my properties, I put my proceeds in notes and syndication and became an LP instead. I am actually waiting for the market to adjust after the frenzy in the past 2 years. The numbers have to make sense. The cap rate is so low in the Bay Area I started looking into other states 5 years ago. Good deals are starting to resurface in many areas in the past few months.
I think investing in smaller MF, such as 4plexes which you can still qualify for conventional residential loans and learn from there. As a beginner investor, you want to get the basic right and not have to deal with too much stress from larger properties.
It also depends on how much capital you have to start, but always look for properties that you can add value.