It can be a great strategy especially if you are in a desirable area (which it sounds like you are).

Assuming an average 8% CoC return and factoring in none of the backend, if I invested a total of $5MM into several syndications (assuming some of the windfall went to taxes), we would yield $400,000 annually.Depending on your current and future desired lifestyle you could continue to live modestly, and reinvest a large portion of the dividends earned. 

Same with contractors, most GCs you will meet aren't worth their weight in scrap metal. 

This investigation is critical to assess whether the investment is economically feasible and will generate the desired revenue.

You can have a couple yoga mats and some light weights in the house if you feel it would add to the guest experience. 

The biggest thing I'm noticing with this listing is the desirability of the neighborhood is extremely low.

I am not against paying for coaching but I believe it is most likely to pay dividends if 1) you know exactly what aspect of RE you desire to pursue and can find a mentor that is a very good fit for the RE you want to pursue.  2) you are very motivated.   

Let's try reframing this @Eric Justice:Buying all-cash, reduces operational impact weight to a level that feels very stress and urgency free. 

A desire and ability to share their knowledge4.

That need could outweigh their desire to protect your best interests.Not saying there investment here is a bad thing, per se, just raising this point so that this one element of the deal doesn’t tip the scale to you investing if you otherwise might not.