Linus tech tips covered this issue before: https://youtu.be/K07sEM6y4Uc
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...
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."