Neither HDDs nor SSDs will last forever.
It's as easy as sticking a pair of drives in a cheap NAS enclosure and listening for the warning alarm when SMART predicts failure or a drive fails.
I did have to replace the previous NAS after 5 years-- not because of failure, but because I needed more storage and wanted more performance. Otherwise it might have lasted quite a bit longer.
This isn't really true-- flash isn't really like DRAM; leakage currents tend to increase even if you don't reprogram things (and to properly fight leakage-related data corruption, you really need to periodically rewrite and do the erases that further compound dielectric breakdown). And it's especially not true of board-level assemblies, where capacitor failure and solder joints become important.
> A hard drive will wear out based on power-on hours and start/stop cycles, regardless of how much you use it.
Some failure modes look like this in SSDs, too. Studies have shown that SSD age is a much better predictor of failure probability than usage. Depending on how firmware handles things and the cell characteristics, -insufficient use- of a SSD can cause failure, too.
I mean, I did some work on firmware for early SSDs and error rate / lifetime analysis and I've had SSDs lose data in a drawer unused, but maybe you know better. Yes, SSDs are better than HDDs, but not as drastically so as one would think.
I <3 flash. But I also like having big dumb spinny disks. I'm rather glad I can have both.
I can replicate this at home with a Samsung 970 PRO m.2 in an Intel NUC. It just will not overheat. The only thing I can do to make it shut down is to put blankets over the NUC in which case the CPU has gone PROCHOT anyway.
Bottom line, it seems to me that power and heat are advantages of SSD, not HDD. It seems like people buy HDD purely because of GB/$, which makes sense to me at scale but not at home. The care and management of hard drives, and their atrocious performance, seems to outweigh the price advantage. It's really hard to manage HDDs successfully and even if you are doing it perfectly, it still means you are replacing the HDD every 3-5 years. What a pain.