We had one growing up in Iowa. Despite upper 70's to mid 80's much of May, June, and July, we were able to avoid running the air conditioner by sucking in the 50-60 degree air overnight and closing up the windows during the day. By late July and August, it was time to use the air conditioner.
The fans can typically rotate all the air in a house every handful of minutes, and the breeze helps sweat evaporate, immensely helping comfort. Their cost is typically a couple hundred dollars, but you can spend up to ~1,200 for a quiet, high volume model.
I'm looking to install one in my house. The downside I'm trying to work through is, should a fire break out, I want the fan to turn off. I haven't found a COTS system to do this and integrate with the hardwired smoke detectors.