Cancun is busy man, maybe to crowded to enjoy. I like slower pace, like Nags Head, NC but maybe boring for kids. You can rent houses that have indoor pools, on the beach, and some have theaters and arcade games, pool table..luxury places and reasonable prices.
I'm going to be up in Boston, but was looking at this site for ideas also: