It's different than a USB floppy disk drive, which is more like a weird integrated ATAPI device on a USB-ATAPI bridge
I'm speaking from experience with ZIP drives, including the internal ATAPI and IDE versions. Support for Linux was dropped a while ago, but you can load that in as a Kernel module. I still haven't gotten that to work.
Current Win10 install kinda works, but the best success I've had is with an old 32-bit installation of WinXP. Even then, doing the things you'd like to do with a floppy drive (reading reliably, reading when inserted, decoupling the unmount/eject ((as opposed to the old way Mac handled it))) mechanism is difficult. Also, some USB->ATAPI bridges simply don't work with ATAPI floppy devices.
If you've ever wanted to solve a problem that no one else has attempted (because no one cares, at all) there's a project for you.
It's wild when I hear/read about production systems still running with old floppy media.
With both drives there was a brief moment the the zip disk showed up, once. Then never again.
I eventually just purchased a PCIe IDE controller card and that works as expected.