I don’t want to recommend products that often, but I actually found this quiet desk fan to be exactly what it said on the tin. Really quiet, and with a gentle breeze that keeps you cool without using a big gale to do so.
If you know anyone with a noisy fan, tell them how much it irritates you and point them at this.