Nice historical collection, but not one I'd prefer to spend a whole lot of money on. (I also deal with old hardware and with enterprise hardware, so I do understand what you're up to here and what you're going through, and I'm very familiar with CD-R/RW, DDS and LTO, and with magtapes as far back as the old GCR-, PE- and NRZI-encoded reel-to-reels.)
Every one of the 4mm and 8mm drives I've tried has been failure-prone, some very nearly write-only media, and with very limited media reuse. (And this was name-brand stuff, with name-brand media.) There may well be good ones out there, but the dozen or so models I've worked with weren't particularly robust, and I nearly had to treat the media as single-use. They're cheap drives that are priced cheaply.
The rated media lifetime on DDS/DAT was on the order of a thousand head passes or so, and the archival procedures I was dealing with could hit that for the tape underneath the tape headers on a dozen reuses or so. Even when it was working, that stuff wore out very quickly.
The DLT and LTO media was rated at some decent chunk of a million head passes, so once you had a batch of media that worked, it could usually be re-used and recycled for a while.
The reason older CD-Rs don't tend to read is usually either low reflectivity, or media degradation. The older CD-R media and older drives were really quite spotty, the drives either weren't sensitive or weren't sensitive to the particular batches of media, or they didn't have the calibrations for the particular media, and the recorded media itself wasn't particularly reflective, and it degrades.
I'd roll those old CD-R disks forward onto newer media, minimally.
And until you're up into the LTO4 or LTO5 range and with the I/O buses to match, tape just isn't a good match for current disk technologies.
Running trailing-edge gear and running a hardware museum (and of which, I fully support) also means you need to differentiate what you're doing to keep your old gear online for historical reasons, and what you're doing to roll forward with and to avoid data loss with the ubiquitous degradation of older media, and what you're doing with your current data.