My feeling/memory was that these failures tended to be cheaper Transcend M2 units used for the database.
If you’re buying SSDs you won’t go far wrong sticking with Samsung.