I think the Royal Resorts are the only way to go! They’re the best of the best to say the least. I’ve been going to Cancun (Royal Mayan and Club Internacional de Cancun) in late October into early November for over thirty years. Very few children, the weather is great and we only got hurricaned on one time (Wilma). The hurricane hit the day we were suppose to fly into Cancun so of course all flights were cancelled. We went a week later. It was the most memorable trip we ever had.
Royal Resorts in Cancun vs. the Royal Haciendas: Cancun has a bunch of restaurants, shopping centers and other things to do and see, all within easy traveling distance of any of the resorts. The Royal Haciendas are very nice but a bit remote. You can go into Playa del Carmen to restaurants and many Mexican shops on a free shuttle, but plan on spending a minimum of a half day on a simple trip to town and if you stay into the evening, after the shuttle stops running, you will need to take a taxi back, a $10 ride. The beaches at the Hacienda and Club Internacional are very nice and easy to get in and out of the water. The other resorts have exposed rocks that present an obstacle when entering and leaving the water. However, there are beach chairs and you can go and sit on them or walk the beach.