Great post @WilliamsKnights . I heartily agree that, even with as many data center years experience as I have, there just too many variables to definitively say "this disk".
I have a 10yo consumer grade Netgear ReadyNAS with 2x4TB WD gold drives that are the ORIGINAL drives! They've survived not only a decade but also 4 moves. Now, I've taken really good care of the hardware but I attribute their longevity to both the drive type, the care they've received, but also...just plain old luck.
All of which is to say that, at least as far as hardware goes, do your research, buy the gear designed for your use-case, take care of them and you'll get as much use out of it as you can.
Cheers!