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.