With the introduction of QLC consumer SSDs, with worse write endurance and life time but the same price as TLC, I took a look at used enterprise SSDs and never looked back. The only issues is the connectors. You need 8x PCI-E lanes (4x might work) or a SAS connector that nearly no consumer board has.
QLC is complete trash and should never be used outside of a WORM architecture in a larger pool. That they are trying to force it on consumers is criminal. Same with SMR.
Not everyone is a creator editing/rendering 4k videos. For the typical surfer/office worker/gamer QLC drives are fine because they rarely need to dump 50+GB of writes at a time. What you're suggesting is basically "ban all atom processors because they're criminally slow!"