Reason for testing so many drives is that when it comes to the real world, a lot of drive manufacturers cut corners and didn't follow standards, so we had a growing list of "work arounds" that we would validate. Every manufacturer would send us their drives to validate, we had a huge closet with shelves floor to ceiling of different drives.
Was a cool internship out of high school an forever thankful that I got it. Even if it's my most boomer skillset.
Couple of main things that post are 100% correct, the brand of media does matter. We actually had specific media we would recommend to the DOD for maximum stability. Second of all faster media always performs worse for archival purposes, and burning faster will result in more errors as well.
For testing we had a specific media for each type we found could be used for 25x tests reliably, but I don't remember the brands/type. We would basically load them once a year since we did a full verification every few weeks.