No, I've not invested with SCDC, and it's not likely I will without evidence they can do / have done what they've claimed on their web site.

I wouldn't invest in MA or NY, simply because of their eviction laws.

I see this as an opportunity to ladder or, maybe more appropriately, cycle of building equity and taking out loans for income. 

The opportunity cost of losing potential market gains in your retirement fund should also be considered.

This does not align with buying most buildings in cash.Once you progress in your investing efforts you may come across more UHNW individuals, family offices and institutions who would take the lower return for limiting risk (all cash deal).

To me the value in diversification is that it helps nudge you to look for other opportunities and revenue streams where you might otherwise just be content to stay in your lane and then you'd never find anything new. 

Looking for ways to expand my network as well as possible job opportunities. 

Given statement of condition, I would think value-add is the opportunity at hand.

I have read the book on long distance investing and still am not too confident to get started.

The biggest investment you will make in real estate is your education.