How can I best keep my room cool in summer?

I’m looking for advice about what sort of portable room cooling devices to look at and what pitfalls to avoid. Some context:

Over the past few years I’ve noticed that I do pretty badly in the heat, especially at night. I live in Zürich, the concept of air conditioning has not yet arrived in this place. The prevailing wisdom for how to survive summer is to just make sure your house doesn’t get too warm in the first place, but my apartment is pretty badly insulated and during the worst weeks it doesn’t cool down that much at night either, so it’s been pretty bad the last few years. I’ve mostly just avoided being in my room whenever possible, but I do have to sleep somehow.

The obvious solution to me is to buy some sort of air conditioning device, a topic I know basically nothing about. My flatmate has one for his room, of the “dangle a tube out of the window” kind, which seems to do an okay job, but it is extremely loud and quite bulky - neither of those are dealbreakers per se, but I’d happily pay a bit more money if that gets me something quieter. In addition, our windows are not sliding windows but ones that open like a door, so any device that requires me to poke something out of the window would probably need a solution for this as well. Any sort of permanent modification to the house such as putting a hole through the wall or the window glass are not allowed.

So my questions are: What types of coolers should I look into, what types are best avoided? Any specific brand or model recommendations would also be appreciated. I looked at one electronics vendor’s website and found a huge range in prices from below 100 to over 1000; I don’t have a specific budget in mind per se, but unless it makes a big difference (e.g. in noise levels) I would rather stay below 500 dollars.