I bought this one for an rv trip. It blows well, has a hook you can hang it on, USB charging (and can charge phones), last over night certainly but you may need to charge it after 2 nights. It's not crazy loud but decently. I use it a lot now in the wood shop where I hang out or in the backhoe.
20000mAh Camping Fan with LED... https://www.amazon.com/dp/B09PNHF954?ref=ppx_pop_mob_ap_share
Regarding the last paragraph, I bought and just used this fan for the first time to cool out the camper at night.
https://www.amazon.com/gp/product/B09PNHF954/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&th=1
It is ridiculously efficient. It has 4 speeds and at the low speed the battery will last 58 hours. I never used it above the second speed, and it never went below 75% charge all weekend. (I also topped off the charge from the 12V plug while driving, so it should work pretty much forever) My camper is too small for any other cooling solution, so I was really pleased that this worked.