If you really want to go down the spinning-drive reliability rabbit-hole, this is a good place to start...
BackBlaze (who run a cloud backup service) publish their drive failures - and as pointed out, there are not that many drive manufacturers any more - lots of companies have been bought out and continue to make drives with the old name but the manufacturing gets transitioned over to the parent company, so you end up with a different drive than you imagined...
https://www.backblaze.com/blog/backb...stats-q2-2020/
https://www.backblaze.com/blog/backb...stats-q1-2021/
Personally, for audio, I think SSDs are the way to go for everything. Internal & external - session drives, backup drives, even small drives for posting to people. USB-C is fast enough for most, as TB enclosures are rather expensive.
Dominic