In contrast, traditional HDDs are mechanical devices. Total failure of a hard drive tends to happen unpredictably. A poorly time impact can result in damage that is fatal for the entire device. Once debris starts bouncing around inside of an HDD, damage can be catastrophic.
I will agree that early flash drives were not as reliable as they should have been, a problem is that mostly solved in SSDs produced today. Software issues in SSDs were a problem in the early days -- I even had an early Intel 32GB SLC SSD that bricked itself even though it was nowhere near the end of its rated life. It takes time for firmware developers to develop an understanding of the problem space and create a sufficiently advanced test bed to exercise some of the more complicated corner cases associated with wear related issues near the end of life. SSDs today are a very different beast than those on the market 10 years ago.
Lately I've been getting some exposure to the archival problem space. Event today, tapes are still an important part of the storage hierachy, especially when it comes to legal compliance by certain large businesses.
They're still a problem. HP had two separate instances of branded SSDs fail when the lifetime counter rolled over (I guess they didn't test everything the first time).
My experience with running around 10k SSDs and spinning drives in a datacenter was that spinning drives would fail more often, but would provide clear warning signs if you check SMART stats regularly, providing opportunity to replace failing drives without losing redundancy if your storage systems are flexible. SSDs would fail significantly less often, but there would rarely be a warning --- disks would just disappear, never to be seen again. Our use was relatively low writes, we weren't anywhere near the lifetime write counts.
Some SSDs would really tank performance if they declared bad sectors, while they were moving things around, host driven I/O was very slow. I don't remember which brand that was.
My personal theory is that consumer gear tends to get better tested over the long run since millions of units out in the field will result in a lot of weird corner cases actually happening. The electrical engineers I know love it when their products are in high volume production, as it makes it a lot easier to find patterns and the underlying causes of failures. In contrast, low volume niche products will always have lurking bugs deep in obscure corners that haven't been exercised.
Flash doesn't fail when it wears out. SSDs simply become read only and get slower over time when they exhaust their write cycles. That's not a failure. A failure is something like your SSD controller bricking itself randomly during a power cut and instantly making all your data vanish.
There are also documented cases of Intel SSDs that should have gone read-only once reaching the end of their wear life failing outright due to firmware bugs. As is usually the case, software failures in corner cases abound.
Do you have anything to back that up? because in real world even Intel server drives simply vanish from the system without prior warning, or promised read-only failure modes.
If these increased areal density techs don't pan out, they are done.