Automatic windows seem hard, but you can accomplish this "easier"(not super easy, but doable if you are a home DIYer) by having a "whole house fan" + a make up

Automatic windows seem hard, but you can accomplish this "easier"(not super easy, but doable if you are a home DIYer) by having a "whole house fan" + a make up air unit(basically a vent that opens up when the fan turns on, supplying outside air to replace the air the house fan takes away). Fairly common to see here in Boulder and the front range in older homes(before ubiquitous AC units), because it tends to be cool at night + hot in the day during summers, so around 5AM you can have the house fan turn on, cool your house, and then you ride that throughout the day until the evening when the temperature starts to drop again. Works quite well IMHO - my first rental had a system like this as well as AC, but I actually never touched the AC.