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.

A company of any size wasn't archiving stuff on freaking floppies. In the 70s and 80s most video games were developed on big iron—PDPs or VAXen, usually, and data from those was archived on paper or mag tape. If you were renting (or stealing) time on one of these, as "Micro-Soft" was in its very early days, then printing stuff out may have been more economical. But major game studios of the day had resources and means of bulk archival that didn't involving buying a bunch of floppies at Lechmere.