By far the best way to find out which storage drives are the most reliable is to run a couple of hundred thousand of them and keep an eye on reliability.
This is exactly what backup specialists Backblaze have been doing for the past number of years and generating regular reports. This offers an interesting insight into drive reliability.
Over 2021, Backblaze added 40,460 hard drives to its pool of drives, making a total of 206,928 drives in total. Of thee, 3,760 are boot drives and 203,168 are data drives.
There's a lot of information in the report to look at, but there are two standout parts from the report:
Backblaze had also been experiencing problems with the 14TB Seagate drives (model: ST14000NM0138) in its Dell storage servers. It seems that following a firmware update the reliability of these drives has improved dramatically.