Enterprise drives, even used ones, are definitely the best NAND for sustained throughput though they tend to use more power especially idle. For most client usage the "SLC" cache is going to be plenty, especially once you hit 2TB and greater drive size. NAND drives, even SCM ones, will never be able to match Optane in low queue depth operation though.
Short rant: if the 2.5" format had stayed we'd already have 16TB client drives and I wouldn't be surprised if every tier was one higher in capacity than it is with M.2.
On review topic: These drives really make me wish motherboard manufacturers would put in some two lane M.2 slots. While this wouldn't be cost effective for CPU lanes (unless AMD and Intel started going down to x2 bifurcation on client) it should certainly be possible for chipset. If they split a pair of the typical four lane M.2 you'd now have the ability to use 4 drives and as long as they were PCIe 4.0 drives run them at PCIe 3.0 x4 bandwidth. On Z890 for example that would mean 1x PCIe 5.0 x4, 2x PCIe 4.0 x4 and 4x PCIe 4.0 x2 without sacrificing anything. I think most client users would take that tradeoff.