Forgive the lengthy post!

Seems like it could be a lengthy process.

I also require my tenants of any length (I only rent for 30+ days) to have their own renters insurance for their own belongings so I don't see any big issue with having your part-time tenants get renters insurance and then making sure that your own homeowners policy is aware that there are others living in your home but that they have separate renters insurance.

Real estate investing can be a great idea for several reasons:Potential for Appreciation: Over time, properties often increase in value, allowing investors to build wealth through appreciation.Passive Income: Rental properties can provide a steady stream of passive income, helping to cover expenses and generate cash flow.Tax Benefits: Real estate investors may benefit from various tax deductions, such as mortgage interest, property taxes, and depreciation.Inflation Hedge: Real estate tends to keep pace with or outpace inflation, making it a good hedge against rising costs.Leverage Opportunities: Investors can use financing to purchase properties, allowing them to control larger assets with less capital upfront.Portfolio Diversification: Real estate adds diversification to an investment portfolio, potentially reducing overall risk.Tangible Asset: Unlike stocks or bonds, real estate is a physical asset that you can see and manage, providing a sense of security.Control Over Investment: Investors can influence property value and income through renovations, management decisions, and property improvements.Building Equity: As you pay down a mortgage, you build equity in the property, which can be accessed later through refinancing or selling.Community Impact: Investing in real estate can contribute to community development and improvement, positively impacting neighborhoods.These factors make real estate investing an appealing option for many people looking to grow their wealth and secure their financial future.It really comes down to investing in a growing market, in a good neighborhood & building a great team to support you.

What would be the return if they put it in the stock market, bonds, syndications, real estate notes, etc.

As used in this Section 18, "Interest in the Property" means any legal or beneficial interest in the property, including, but not limited to, those beneficial interests transferred in a bond for deed, contract for deed, installment sales contract or escrow agreement, the intent of which is the transfer of title by Borrower at a future date to purchaser(That’s the exact definition of an Executory Contract that he says to switch to) Banks aren’t stupid. 

As an only child, my mother means the world to me, and I cherish the bond we share.

(Promissory notes or corporate bonds) Issuing debt gives your investors a 1099, because those payouts create a tax event.

I have an IRA/SDIRA and stocks/bonds increase in value, the balance goes up each year (minus the mandatory SEPP payments) correct?

Equities, stocks, bonds, real estate, gold, silver and everything else is going to increase in nominal value but not necessarily in real value.