I do not like these in NC, however it is a tricky situation which requires me to have buyer and seller sign an acknowledgement and waiver of a conflict of interest.

Even a bond with the state wouldn't be that big of a deal.Whatever, I'd think the best way to get changes is to acknowledge the problems, work with them, find simpler solutions and implement standardized practices.

You could have your lawyer draw-up an agreement/addendum to your shareholders/partnership agreement acknowledging that your partner's child support arrears will be paid by the partnership out of his share of any income or proceeds.

It is hereby agreed that during the terms of this lease, LESSOR/LANDLORD does not assume responsibility for any of LESSEE/TENANT’S furnishings or possessions, wherever they may be kept on the premises, for any cause whatsoever.LESSEE/TENANT acknowledges that LESSOR/LANDLORD’S insurance does NOT cover personal property damage caused by fire, theft, rain, war, acts of God, acts of others, and/or any other causes, nor shall LESSOR/LANDLORD be held liable for such losses.

Also, assuming you were dealing with the actual owner and are not the victim of a fraud, this problem should be easily fix by obtaining a new deed from the Seller or if the only problem is with the Grantor's name at the top of the deed and not with the acknowledgment at the bottom, it may also be possible to fix the problem with what's known as a scrivener's affidavit.

On the contrary there are stern fraud warnings repeated several times in the acknowledgment section.

But even the aforementioned accountant acknowledged that I'm well educated for a dumb engineer.

This is a killer and I can't find anything even acknowledging the state tax bite, much less how to minimize (if even possible)2) If I want to roll a portion of the proceeds into a new personal residence, must I pay full cap gains on those proceeds then invest as fresh cash?

Its normal to be nervous when you acknowledge inherent  risk.

Have them sign some acknowledgment that they have been warned and provide that and a copy of the lease when they inevitably smoke in the house again.