I've had good luck with the SD-USB-M2 drives. They're all pretty temperamental as the alignment on the heads is quite sensitive, sometimes that equates to not reading LS-120 disks, but they can often still read floppy disks because that's using another set of heads. They're as complex as ZIP drives and sensitive to shock movements.
You might have more luck with the laptop type, most of them were made later than the regular 3.5" size and so they generally work more reliably.
At this point I have a lifetime supply of both so here's the text search I do on ebay to find all the superdrives: (lkm,"sd+usb+m","sd+ppd")+(drive,fdd)+-(flash,hdd,hard,clarion,hdmi,cvt,belt,tape,bmw,kymco,sata)
To use the laptop type, you can get hold of this adapter to use them with desktop PCs 😀 https://electronicsluckydip.com/store/LS120_Adapter_PCB.html
As an aside, ages ago I designed up a faceplate to use the 'shucked' external drives in a desktop PC. Here are the files before I forget about them again. Here's what it looks like: Re: What retro activity did you get up to today?