Not only did it quickly replace the indoor air with cooler outside air, it would also ventilate the attic, preventing it from quickly reheating the upstairs. I could run it for 5 minutes and get the desired effect, maybe 10 minutes in an unusually hot spell.
Not unless you wake at 3AM to implement it. In summer, by the time most people go to bed the temperature has not dropped significantly yet.
Where are you talking about?
I used the technique I described in eg London, Sydney and parts of Germany. Most of the time, temperatures had dropped quite a bit by 22:00. (But not always.)
Now I live in a cooler climate. The highs can still get as high in the day, but it does cool of at night - nearly as soon as the sun goes down.