I was under the same impression about window units till recently as well. However, I learned that there are units with hoses and foam seals that just require to put the window on tilt and then the hose goes out at the top and the surrounding area is sealed with the foam. Not as good as a minisplit but it works and is DIY.