It really depends on location, quality of home features, amount of privacy for renters/members, and competition.

The quality of those constructions in Mexico is generally top notch.

With regard to your "DST" and as with many highly structured tax vehicles that have a potential "self dealing" quality to them, there are a number of potential potholes you can easily step in along the way (e.g., constructive receipt doctrine, effective control over nominal 3rd party relationships, lack of genuine risk bearing and compliance with transactional terms, etc.).

Yes, you will likely pay close to or at retail value if you are buying a quality property that has been properly renovated. 

I learned that it's better to go for quality the first time if you want it to last.Did you work with any real estate professionals (agents, lenders, etc.) that you'd recommend to others?

Buy from a quality builder in a neighborhood which is going to appreciate.  

(Ask me how I know this.)You'll be priced out of virtually any quality market as you'll need to put anywhere from 25-40% down if you'd like to cash flow in a deal you don't have to significantly rehab (or found off-market) with interest rates where they're at (and don't expect them to go down to 4% anytime this decade either--a 3-4% interest rate is historically low and investors in the 2010s were lucky and spoiled). 

Another key aspect of creating generational wealth is investing in high-quality properties.

A few things to keep in mind:Section 8 requires the property to pass an inspection based on HUD’s Housing Quality Standards (basically making sure it’s safe and well-maintained).The rent you charge has to align with Fair Market Rents (FMRs) in your area, so it’s good to check what similar properties are renting for.You’ll still be responsible for maintaining the property, but the upside is that a chunk of the rent is guaranteed by the government, which can provide steady income.Check with the local housing authority about any specifics for your area—every jurisdiction does things a little differently.This could be a great niche if you can find a good deal on the land and make sure your expenses (like maintenance, insurance, and occasional vacancies) are covered by the rental income.

You should focus on the quality of the agent, not the amount they charge.