I bought 30x X25-E SSDs from 2011 because:
- Spinning disks consume 5-10W when idling (as in ready to read/write idle).
- Spinning disks have 2 motors (spin and head driver) that inevitably fail.
That said the SLC(1) -> MLC(2) -> TLC(3) -> QLC(4) layers is a race to the bottom with increased complexity and failures over time!
These are the reasons big actors still use tape as storage medium!!!
There is no great solution, but 64GB 50nm SLC SSDs from 2011 have the best write per bit that will ever be seen (100.000), they only use 0.07W on idle and ~2W when writing/reading. So if your motherboard has alot of SATA ports it might be the best solution until some real innovation happens!
Edit: Maybe I'm the only person in the world that can have 5 million customers on 512GB? Atleast I can have them for 250 years if they all write to the database every day now no matter how expensive electricity becomes!