I spent a week in Cancun, ate everything I could find that was busy on the side of the road where the locals were eating, and was absolutely fine.

No running water and no toilets were fairly common in a lot of the smaller places.

Never got sick once.