Despite being a beach lover, I am fairly sensitive to heat and humidity. YMMV but I did just fine over Labor Day at Palmilla last year. It was a little humid but nothing a dip in the pool couldn't fix. I was surprised how nice it was. As humid as Cabo may be in late summer, Punta Mita will be worse.