Mitch already touched on it but this is a good example of "correlation does not equal causation".

For example when someone wants to have financial freedom and spend more time with family, but then sets a goal by creating a heavy active income stream that involves their personal involvement daily.

In Canada we have a 25 year mortgage (for example), but we renew it every 1-5 years (they started a 10 year one as well) at the current interest rate. 

Condo's are usually on the cheaper end of cost for appraisal reports, typically not $750 (but if it's a high end condo or in an area with there's some complexity, the fee can reflect that). 

In a 1031 exchange, the replacement property must exceed the total sales price of the property sold ($700K in your example), not just your equity portion.

If i sell my SFR rental for $450k and equity is, for example, $200k...Can i invest 100k into a new SFR worth $275k and invest the remaining 100k into a sponsored DST or TIC (which deals are usually multiple hundreds of thousands of dollars?

True, but (a) they were typically experienced investors, and (b) today's market includes record prices and high mortgage rates, which is a double whammy. 

Typically, most cities allow for 30 day minimum rentals.

While I don’t typically work with real estate agents to find deals, I do collaborate with other professionals throughout the process.

I have looked for examples of landlords that were protected by their LLC and always come up empty handed.