There are certain workloads that SSDs aren’t perfect for.
Using them as scratch disks for lots and lots of non-random writes is one of those.
Consumer flash’s number of write cycles per cell determines this.
We use SSDs in all of our SCADAs now and have had great luck with them. Some tweaks are required, disable defrag, disable indexing, etc.