Far as humidity or weather, there is no significant difference between the two.
Home prices on average tend to be higher in Cary and maybe taxes and traffic.
Cary is closer to the beach, Huntersville closer to the mountains also Lake Norman and Mountain Island Lake.
IMO both deserve a second visit and focus more on pretending your living in either city with doing things you would do as a resident vs doing things vacationing.