Still very good weather, no chance of it being cold. You do have a chance of a hurricane as it's still season.
Hit or miss, we've been in October where it rained every day and we've had other trips in October where it was just as nice as April/May. Either way I rather be in rainy Cancun than at work!