my workhorse USB pendrives are some old Buffalo 8 and 4 GB sticks that still work.
They are SLC and were extremely expensive ($150 for the big one back then), but worth the cash.
I have some 1GB industrial 'disk on modules' as OS-9 boot devices, also SLC and 2 8GB Sata as SLCs (Transcend), one adapted in a Mac G4 Cube.
Imho they might be more 'secure' in a non-ssd-supporting OS, disk management is crucial on such drives - the data lives in software literally.
Performance isn't outstanding, but the drives are silent and faster than their mechanical counterparts anyway. You don't experience the same effect as in current desktop models.
Probably there are timing constraints in the disk driver software of the classic MacOS.
Which even more applies to DRam based systems.
I have one as a PCIe card in Windoze-7 box, but it's lightyears behind it's performance capabilities in regular desktop use.
Needs a server-app to drive it to it' limits, otherwise it's just a fast disk.