I'd guess that any of these media is sketchy for long-term archival storage.
I've got probably 30 5.25 floppies in my house, and I have a 5.25 drive and an old motherboard that can probably recognize that drive, and I've got the cables to connect the drive to the motherboad (and power supply). I'd guess that there's maybe a 20% chance that, if I spent a week trying to mash it all together I'd be able to get some data off of some of these floppies.
On other magnetic media the chances are between "haha, no" (oh, you've got an old 8 inch 10mb Bernoulli disk?) to 5% (oh, a QIC150 tape).
On the other hand, if I found a stack of moldy greenbar printout of some data, I'd say that most of the data can likely be recovered, and likely for not a tremendous amount of money.
Get a Greaseweazle and that floppy drive will work on any modern computer (macOS, Windows, Linux). I've been backing up floppies from a disorganized retro PC collection I bought, and almost all of them still work.