My "shop" is my garage, in Florida, in summer. It gets hot, on top of being humid.
I found that a cheap 7" desk clip-on fan works perfectly to help keep me cooler. It's clipped to a shelf 3 feet away from my work/standing space, it's small factor doesn't get in my way, and it's not so powerful that it blows dust everywhere. It's also quiet, which is important to me. As far as longevity, it's a $10 fan; I don't expect it to last me forever (2-3 summers if I'm lucky?). It'll get dust in the motor eventually, the bearings/bushings will fail ... and I'll buy another one.