And yes this will be a huge learning experience.

@Stephen FlemingFrom my experience working with over 400 investors, your strategy of leveraging a low mortgage rate, tapping into home equity, and diversifying with a short-term rental (STR) in Northern Michigan is well thought out.

Rent control in the bay area can be extreme as many areas have rent control in excess of the state mandated rent controlIn general experience RE investors are not choosing to add a single ADU in single family zoned areas.  

What you want is an agent with experience who knows how to negotiate, watch your back, navigate difficult situations, understand contracts and law, provides an objective cross-check, etc.

AIArtificial intellect is not (at least not yet) a replacement for the actual intellect and experience.

So I missed out on taking a year off with my wife and kids and just fully enjoying the time we could experience together. 

Not disputing your experience and I'm sure your agent is great.However, the Goosehead model is designed for the local agent to sell and the corporation to service.

Does anyone have experience with the BRRRR loans?

@Chris Seveney While I'm not at that level to be able to provide personal experience I will follow to see what others respond with.One question I would have is, 'What is your current loan volume today?'   

Becoming a real estate agent is a good idea to gain experience, but you could also explore property management, wholesaling, or working with an investor to build your network.