> in my experience ALL my 24/7 drives from 2009-2013 still work today and ALL my 2014+ are dead,

As a counter anecdote, I have a lot of SSDs from the late 2010s that are still going strong, but I lost some early SSD drives to mysterious and unexpected failures (not near the wear-out level).

Interesting, what kind where they? Mine where all Intel.