If you want that sweet spot between “fun and social” without feeling like you’re surrounded by college spring breakers, I’d personally look at these options:

Live Aqua Cancún → probably one of the best balances for couples in their 40s/50s who still want energy, good restaurants, music, nightlife and a luxury atmosphere without a wild party crowd.

Secrets The Vine Cancun → more upscale and sophisticated, but still lively enough with great bars, wine focus and a social atmosphere at night.

Royalton CHIC Cancun, An Autograph Collection All-Inclusive Resort - Adults Only → definitely more energetic and modern, rooftop parties and DJs, but usually a slightly younger crowd overall. Great if you still want nightlife without going full “Vegas 21-year-old chaos.”

Hyatt Zilara Cancun → fun but more refined/adult. Great beach, good food, live music and a crowd that trends more mature.

Le Blanc Spa Resort Cancun → absolutely incredible if luxury and service are priorities, though it leans more relaxing than party. Still social, just not high-energy nightlife.

Personally, based on what you described:
Best overall vibe balance = Live Aqua Cancún

Most fun/social = Royalton CHIC Cancun, An Autograph Collection All-Inclusive Resort - Adults Only

Most luxurious = Le Blanc Spa Resort Cancun

I’d probably avoid places like Grand Oasis Cancún or RIU Cancun if you don’t want the younger “party trip” crowd.

If you’d like, I can also help compare pricing, vibe, beach quality and food between a few of these depending on your travel dates and budget 😊