Add in massive inflation and cheap markets actually start to appreciate faster than historically in-demand markets, simply because people are literally forced to move there to survive.

Any type of investing has a certain amount of risk, historically for syndications the largest risk has been the operator you're investing in. 

Lawrence Yun with NAR:- 10-year treasury yield is usually 2% lower than prime 30-year mortgage rates; the current spread is abnormally high between the two- Inventory is slightly over 1M nationwide which is historically low- First-time homebuyers, on average, need an annual income of $85K to comfortably afford a starter home; median home price will be 10% higher in 2023- 15% decrease in home sales in 2022 compared to 2023- 1 out of every 5 transactions are being cancelled; 60-64K transactions cancelled a month between July and now- 200,000 less agents in 2023 compared to now; 70% of agents and 80% of mortgage lenders have not worked in a "normal" market2023 Predictions:* -7% Unit Sales* +1% Home Values (various areas may see a decrease)2024 Predictions:* +10% Unit Sales* +5% Home ValuesI agree with your leading point - definite shift in the market, yet real estate is cyclical, so this should not come as a shock to the majority of people working in the industry.

Interest rates have been historically low for over 10 years.

I invest in Fresno, CA which historically speaking has not been the hot rental markets such as Bay Area and LA and thus I suspect any rent control version adopted by Fresno would be different and I am just not sure how to plan for it. 

A weaker location, would have to do some re-calculations.If you have used historical data on a project you are running the numbers on, you might re-do the figures and challenge them."

House Hack an expensive entry to market yet historically appreciating asset or OOS cash flowing SFRs?

You definitely don't want to over-leverage, but this is a historically great time to borrow money on cash-flowing assets, and leverage is the special sauce that can transform real estate from merely cash flowing to multiplying your wealth.  

At one point they even discussed how aggressive that they have been and that they will continue until they see inflation under control or until something within the system breaks and forces them to pivot.I believe the new bank failures are just that, historic record breaking rate hikes have caused new problems within the system and these bank issues are a prime example of that.Now the question is will the Fed try to band aid those new issues so it can continue the larger fight of battling inflation?

Historically, the market bounces back, but clinging to that “trust” is challenging during the downward trend.Multifamily Real Estate InvestmentsRecessions are sometimes good for commercial multifamily real estate investments, especially for workforce housing.In good times, incomes and savings rates are higher, which means more people tend to move up to class A (luxury) apartments.When faced with layoffs or pay cuts, homeowners may sell, and renters of class A apartments may downgrade to more affordable apartments (class B or C).Hence, during a recession, demand for apartments actually tends to go up, thereby decreasing the risk.