If A/C is the ultimate answer, I agree with the split system suggestion. I had one installed when an exterior seasonal room was made permanent (far cheaper than figuring out ducting through concrete and trying to get adequate cooling from the main system - but cheaper because I didn't' use a mainline dealer to install).
Efficiency of the better splits is incredible.
But for folks who say a fan will never work, it's a matter of what you're used to. First 15 years of my life were in PA in the USA and I slept with a fan. Not sleeping well was rare. One fan set back from the window pushing air out (as long as it's not pushing against the prevailing wind direction) and another light low speed (quiet) fan on the person sleeping and comfortable sleep is had.
it gets far hotter in PA than it does there. Not uncommon to have a week or two stretch with dewpoints higher than you see there and temperatures in the 35C range. Before fans, etc, it wasn't uncommon for people to sleep outside on the hottest days.
Once you give in to the A/C, it's hard to give it up, though. Splits are more efficient, but above and beyond that, their efficiency advantage over cheaper stuff goes up as temperatures get more extreme. Mine will make 18-20k btu on a 1kw draw at 90 degrees F, despite being rated slightly lower (the cooling rating is at something like 98F or 100F), and it has to get well below freezing before it starts to get inefficient (from drawing another kw for a pre-heat coil) when used for heating.
The unit cost (mitsubishi) was about $2k total for lines and both parts (outdoor unit and indoor head). The local authorized installer wanted $5500 installed to start (installation takes about 4 hours total - plus you need an electrician to install a whip disconnect here, and either you or the electron guy needs to put in a dedicated breaker at an exact amperage - if something goes wrong with the machine, it has to have a limited breaker size so that if it goes bonkers and starts to draw huge current, the breaker trips).
At any rate, the contractor discouraged me from installing it myself, so I paid his HVAC guy $750, and even that guy was hesitant to install for fear of a territory war with the other con jobber who handles the brand.