I have got one of these
https://www.robertdyas.co.uk/signature-portable-7000-btu
it is supposed to cool rooms down as low as 18 degrees, but in reality, it does not, it basically relative and will reduce the temperature by 3 degrees max. that does help though, and the air it blows out is chilled so it is nice when you are near it. but my plan to leave it on for a while to cool down a room that has been heating up all day in the evening does not work.
the hose out of the window isn’t too much hassle, you get these window sealing kits
with hindsight I would have just got a high end fan, and a dehumidifier for muggy weather