The August cooling trend continues with below-average temperatures, with a spotty shower and thunderstorm chance through Wednesday