For a backup drive that's plugged in at least every 2-3 months, an SSD is great if the price is right.

For proper long term cold storage, you want tape.

There's a niche in between where hard drives are good on their technical merits, but it's not a huge niche.