I've invested an LP in quite a few CRE syndications, I also syndicate multifamily primarily in the Midwest. I don't do any paid coaching/mentoring, although I have several (non paid ) mentors and informally mentored several investors and syndicators.
I've been fortunate to have partnered with some great operators in a variety of asset classes including industrial, medical office and commercial office.
One thing to keep in mind is that in real estate, like in life, things will rarely go according to plan. Deals will go wrong, and it's not always the operators fault.
It's much less important how good the pitch deck looks and how solid the pitch is and more about the operator's ability to tackle adversity and solve problems. I've been in deals with capital calls, distributions suspended for over a year, but in almost evert case the operator was able to navigate the problem and beat pro-forma total return / IRR / equity multiple.
We've gone full cycle this year on 3 deals (2 as LP one GP) and will sell another 3 (as an LP), all have vastly exceeded projected returns for IRR and EM. The market and compressing cap rates making much of this possible.
There are certainly horror stories out there like @Account Closed mentioned. My experience has been the opposite, however.
I'll also say that investing as an LP has improved my syndication business in many ways. It's another way to leverage my time, it's also been a great way to see how other's work and find ways to improve.