Short-term is to move into the space by January 2022 (as my lease ends then) and live there for at least 1-2 years.If I get the duplex, I would house-hack until it was my time to move somewhere else and rent both spaces within the duplex.

Tons of recreation as well so could be good for a short term rental or medium rental

Our recent mid-term rental guests moved out and left the place immaculate.

It's a means of producing income, not long-term wealth. 

Vanilla) 0% Down and 0% interest, 20 year term, Sellers's Asking Price- 8.314 Million-This would be ideal, the monthly Finance payment to Seller would be 23,094.44 and the Rents will cover that and leave another 10k in cashflow.

Those that are likely successful have a lot of prior investing experience. 

Short, though very knowledgeable, was behind the times on how he fielded the, "How do you get a significant other excited about investing?"

Until you have experience in partnering with others on successful projects, I highly recommend working with your partner and an attorney to structure an appropriate, legal, and viable operating agreement, be it in context of an LLC or otherwise. 

But, assuming you have a decent net worth (congrats on all of your successes thus far!)

Has anyone successfully done this before?