I have been to Puerto Peñasco aka Rocky Point. I think it'll be a good destination for your purpose. It is a safe area that caters to the US tourist dollar

There's your average paranoid American who thinks the second they step off the resort property they'll be kidnapped and killed. Which is completely false. Then there's the "enlightened" American tourist who thinks Mexico is completely safe, which is also false.

I have been to a lot of parts of Mexico, including many "unsafe" areas. In general, if you aren't looking for trouble, and handle yourself with confidence like you belong, you are very unlikely to be a victim of a serious crime. At worst usually, you'll just be overcharged (aka gringo tax) or a victim of petty theft if you aren't vigilant.

The level of poverty across the border can be jarring to the first time visitor, in particular when you cross back into the US there will be many beggars, stray animals, and run down buildings.

Mexico can be a beautiful place to visit, with great food and good people in general. Keep a nice balance of situational awareness without being paranoid and you should have a good visit.