Even if you get this data, it is not uncommon for SSD manufacturers to change the original NAND chips for inferior chips without changing the SSD’s brand name or model number.
They use them as a boot/system drives without a big load. And when you have more than 500 drives some would die just by pure luck (or lack of it). Mishandling, static charge etc...
Yes, but you're not going to like the answer. Despite many industry professionals on this site, there is a large number who, by most definitions, never had a real job. Nothing wrong with that, but they're real loud, and they like to put down proven reliable solutions because they cost too much, and then slap on random terms like "zfs" that magically fix all problems.
The equivalent is in short "look at what the enterprise storage vendors are putting in their arrays, at 10x markup. (No, shiny things like Pure/Rubrik/Cohesity are not enterprise storage).
It all depends what you're putting on things. If you buy 5 drives from Newegg for your house and double-parity them or do zfs checksums, etc., you're going to have a bad time when a bunch fail at around the same time because it's an issue with the drive. Yet you do kinda want all the same/alike drives, because the stripe is only as fast as the slowest drive.
So look at what all the vendors picked after they tested the crap out thousands of them all. Me, I personally just mirror everything between two machines with different brand drives, and hope they won't fail at the same time. Once a year I dump an image of everything on an offline big-ass drive - the cheapest spinning big rust that I can buy - and call that my "airgapped vault."
Linus tech tips covered this issue before: https://youtu.be/K07sEM6y4Uc