First, thanks for all the input everyone! I appreciate it.
My backups are personal backups. Nothing work related (retired). Stuff like tax records and old personal data I like to keep. While typically recommendation for tax records for 7 years, my understanding is that the "statue of limitation" doesn't apply with at least US federal tax and perhaps States as well, so I am targeting at least 10 years.
My current approach is mirror on magnetic drives for video, photos, and other less important stuff. For more important (tax and such) is to also do an annual DVD (8gb) backup as 2nd source.
I think I will stick with HDD for now since it is lower cost than SSD and is as durable as SSD (assuming it is not dropped or otherwise physically damaged.)
..
I wouldn't rely on broad classifications to make such decisions, I'd look at the historical failure rates of specific models. For me SSDs are only Samsung and not the old 840 series. HDDs are various HGST models, the Samsung (now Seagate) 2TB 2.5" M9T (for laptop internal backup) and for big non-critical stuff (media) the 8TB Samsung 3.5" drives shucked from external enclosures. The last are low-power, low-RPM and SMR, but so far so good. YMMV and it might pay to read the reliability reports from BackBlaze.
As far as time and potential bitrot, I've been running a Samsung 830 for 10 years and that computer is now only used occasionally. No issues or errors.
I am not sure "historic data for specific model" matters in today's competitive environment. Even Samsung has been caught in
"SSD Bait & Switch" . That is the practice of a
good initial product, and after a while (long enough for benchmarks and tests done by publications and users to be done), they
switch over to inferior parts with much worst performance
while still sell them under the same model/sku. I have both Crucial and WD Blue, they both are "on the list" of bait & switch also.
This two are not the only videos I found on the topic, it just happens to be the first founds: