If you want real data instead of feels, look at the BackBlaze report they publish every year. Even within a particular manufacturer varying models can have widely different failure stats.
https://www.backblaze.com/blog/backblaze-drive-stats-for-2023/