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.
Only device managed SMR is terrible. Host managed SMR is fine for data-hording if the savings in size/price are forwarded.