My goal this year is to go from analysis paralysis to taking action.

The people the seller should have this discussion with is the title company and or legal counsel.  

You may be safe to get non-commercial F/F adding up to 2 ADUs to a duplex even though by rule this does not qualify (in my area I have never heard of this being an issue). 

You'll improve over time, but this basic formula remains.1.

This might only apply to RM1. 

I started down this path years ago, taking our pre-existing lease and adding on and adapting it to this utilization.

This will clarify and reinforce what you are reading.

Quote from @Anshuman Thakur: Can someone please shed some light on how- convert 401k to SD IRA- how to use SDIRA to buy properties- how much down payment is typically required if we are using SDiRA to only fund downpayment on a multifamily CRE, and which banks typically work with SDIRAs- how does LLC structure- property management and cash flow work in this situation?

I hope you don't like this family member.

If there’s no exit clause I’d take this opportunity to add one.