Not in Cancun but you’re probably want to hit Playa del Carmen or Tulum.
Cancún has nice hotels and some mega-clubs but that’s about it.
Playa del Carmen has restaurants, small cafes, bars, nightclubs and beach clubs. Also a big community of expats.
Tulum is a recently trendy small town where the wealthy go for vacation.
There should be top notch women there.