It seems like your typical ETF or mutual fund is easier to get into and get out of, just a few clicks on your brokerage of choice.
Your answer brought up the obvious general answer: the only way to make passive income from investments is to already have a lot of money. To me there's a point where the method of investment almost seems like an irrelevant detail.
I ultimately bought a house where I could rent rooms out on airbnb or to renters instead of going with a syndication. The main factor was getting leverage: a 30 year mortgage at 2.8% APY is basically free money.
Airbnb is not passive, but I look at it this way: I'm going to live in a house anyways, I might as well get into the business of living.
I do assume you can’t just take out a loan to join a syndication, but lots of people rent duplex units and vacation homes as you describe. Thanks for the answer!
A few possible reasons to go private: a) smaller and more entrepreneurial operators can produce better returns b) capturing the illiquidity premium.
So buyer beware.
If you want something more passive, consider investing in several different real estate syndications. You can find them on CrowdStreet or FundRise although I believe you will get into better deals if you join a local investor group and learn from the experienced members. If there isn't a group near you, I'm enjoying participating in www.506investorgroup.com
This style is probably only practical if you already have a net worth of at least $1m. The best book I've found is Investing in Real Estate Private Equity by Sean Cook.
I think it is reasonable to expect a diversified portfolio of real estate syndications to return 10-15% annually although it will be bumpy and your money will be locked up for years.