I've come across several USB drives that don't work in Mac computers at all (I've tested on 3 Mac computers, so it's not a problem with the USB ports in a particular Mac machine). No drive appears in the desktop, and I can't find it mounted in /media/, nothing! A similar thing happens in a Linux machine (Raspberry Pi OS).
One of the drives is a no-name drive, but the other one is Philips. And they're NOT using the NTFS filesystem (even then, it should appear as a read-only filesystem in a Mac anyway).
So, why do they only work in Windows? Is there anything in their firmware that might make them work only with Windows machines?