From my observations, there are two paths for people who go to Mexico for vacation: you go to Margaritaville (in the Cancun airport), you take the shuttle (to Cancun), then you go to the Margaritaville (in Cancun). Or, you adventure.
Once one of my father-in-laws got botulism from Mexican beach oysters. He couldn’t leave the hospital for three weeks. On a separate trip, my other father-in-law also got food poisoning from Mexican beach oysters. He had such violent diarrhea he started hallucinating. Both fathers-in-law wouldn’t hesitate to come back (but not together). Both also have a new outlook on non-refrigerated raw seafood.
There is also a third, but rare type of person who vacations in Mexico: I read a news story about a woman who traveled to rural Mexico to get steeply discounted butt implants but was instead abducted by the cartel.