Out of 10 3TB WD drives I have that are roughly 6-7 years old, I've seen two show a few read errors each. I think the general consensus is to replace HDDs about every 5 years, so I've not done bad.
SSDs, particularly modern TLC/QLC ones, are not great for cold storage. I've got a Samsung 840...