I think a big problem too is that SSD prices haven't gone down fast enough. Basically the only reason that spinning rust is still a thing, is because SSDs are far more expensive.
[1] https://www.backblaze.com/blog/open-source-data-storage-serv...
[0]https://www.newegg.com/nimbus-data-dc-100tb/p/2U3-002M-00004...
Something like https://www.supermicro.com/en/products/system/1U/1029/SSG-10... can fit 32 SSDs à 16 TB in a 1U system (Intel at some point announced 32 TB models in the same format, but I'm unsure if they ever were available).
This style can fit 48x 16TB in 2U: https://www.supermicro.com/en/products/system/2U/2028/SSG-20...
The trouble with such dense SSD capacity is more being able to interface them fast enough with the host and the outside world.
So, what workloads did you have in mind when you said "generally"?