I have a partial solution to some of my heat woes. This is a miniature swamp cooler, basically, but for a room, and it comes with ice packs you can swap in and out when you fill the tanks with water to help cool things somewhat. It works surprisingly well, though it is, because of size and capacity, limited.
https://www.amazon.com/COSTWAY-Evaporative-Control-Function-Portable/dp/B0BYF1ZPY6/ref=sr_1_7
Follow
@XaoslordErie @see_the_sus those work great if you're in a dry area. Totally do not work if you have humidity.