So this guy was going to put nothing down, pay the mortgage payments, and when his business failed, put all the liability on seller and bounce.He even found out that my seller broke his help and was explaining to me that this is his best case scenario because he only had 6 months to live... 

A net worth tracker is a web-based or mobile application that tracks your assets and liabilities.

If you’re looking to build REAL wealth, then leverage of one type or another is necessary.Debt is one type of leverageSyndicators leverage investors capital as equityStart up companies leverage Venture Capitalists investments in both equity and debt.The real estate investor has 3 distinct “cycles” with debt leverage1st stage is debt secured by real estate but also personally guaranteed and often cross collaterialized2nd stage is debt secured by real estate but liability not personally guaranteed and recourse limited to specific property.3rd stage is debt free If you own units in a syndicated real property investment and the investment is leverage by debt you may not think of it as YOUR debt because you’re a passive investor, but your investment is encumbered by debt the same as property you own individually IF you haven’t personally guaranteed the debt.  

They can only provide a general liability-only policy through Lloyd's, which doesn't cover the physical structure or contents.If anyone knows of a good insurance provider that offers comprehensive coverage, including protection for the structure itself, I would greatly appreciate your recommendations.

I have already created a single member LLC in my name (husband) and the attorney said that it would be fine to proceed this way and that it would allow me to self-manage and maintain liability protection.

Like others have mentioned, it's beneficial to you and your business partner to ensure the LLC is established in a way that does in fact limit your liability. 

Using a DSCR loan that allows closing in the business name is a great way to separate personal liability from the business.

They have joint and several liability.  

Here's another perspective: Insurance is for liability protection.

The liability from the DSCR loans will still be calculated on your business tax returns.