I'm from Mexico. I still spend plenty of time every year and/or have family in states under the "Do Not Travel To" or "Reconsider Travel To" lists.

In my experience rather than having "nice tourist locations", it has the opposite: "dangerous crime locations". These are usually along the fault lines of cartel territories or in specific "sketchy areas". Mexico is nice for us non-tourists living in non-tourist places too IMO.