Cloudy weather, rain, cooler temperatures and thunder and lightning in some areas will bring relief after weeks of warmer than average conditions