That's exactly the type of ac unit I was talking about. Place in the window, drop the sash, expand the accordian sides and done. Noise is not that bad. You definitely hear them, though. I once had a unit with a dual inverter that was so quiet that you barely heard it. Cost a bit more though. Now I have a cheap one that makes more noise. Sizing is important also, to work better with multiple rooms.
I built a house back 25 years ago. Never had ac, just ceiling fans. As the climate changed we added 2 window units to cool it. Now I can't imagine life without one. The new house will have central ac. Our heat wave is coming next week with temps in the 90's f to at or near 100 f most of the week.(32c to 37c) 😅