What most of them are is nothing more than an exhaust fan. An inexpensive box fan put in a window will exhaust the heat just as well, but neither cools the air.
To get one that will do some cooling, you'll need something like this:
https://www.amazon.com/Gasbye-Portable-Conditioner-Compressor-Energy-Saving/dp/B0DXKBG6LT/ref=cm_cr_arp_d_product_top?ie=UTF8&th=1
Even then, it has limitations and will only cool a single room and might not adequately handle really hot weather (90s and above).