Without ECC, modern systems (>= a few GB RAM) will have bits flipping pretty much daily.
https://storage.googleapis.com/pub-tools-public-publication-...
I think the environment in racks for nodes in whichever formfactor in racks is toxic. Be it EMF interference, power distribution issues, vibrations, and/or temperature. You don't have that in a single system at home, when it is built in a good way, and has stable power. Or at least to a lesser degree.
Ultimately these flips are caused by charged particles hitting the memory module (a so called 'single event upset' or SEU), and the number of charged particles hitting the modules has not increased with density (although the modules are more sensitive to SEU, it's a smaller effect).
Until they happen more often that expected. It's something that varies based on building, temperature, etc. environmental factors. And of course on your luck with memory module lottery.
https://storage.googleapis.com/pub-tools-public-publication-...
Is ECC useful for a workstation? I thought it was useful for shared servers (VM hosts) to protect against rowhammer & co, but does is have other uses?