I would look for a dongle that specifically markets itself as being Raspberry Pi compatible. Most stuff you find will prioritize Windows, but if it’s marketed to work with the Pi you know it’ll have at least some level of Linux compatibility. Once you find one, try to figure out what chipset it uses, then search if it’s supported by a handful of the distros you wanna try.
Linux support for wifi in LiveUSB trials with onboard wifi chip and/or additional USB wifi dongle
EDITED November 28, 2023 to add:...