Unless you are running a multi-user server, don't throw your money away.
Even there, they are a niche product. They are typically reserved for things like holding the journal of a filesystem RAID'd over several NAND-based enterprise SSDs or to hold the index for a distributed filesystem. Both write-heavy, high-IOPS tasks, where you don't need a ton of capacity.
Optane died because it did nearly nothing for Windows consumers PCs
Nah, I think consumer was very much a secondary market.
They died because their capacity scaling is so bad that they'd even struggle to be price-competitive against DRAM-based, NAND-backed drives, which would smoke them on performance, where & when it counts.
The P5800X @ 800 GB launched somewhere around $2500, which works out to 0.32 GB/$. Current pricing on 64 GB DDR4 ECC RDIMMs is 0.44 GB/$ (provantage) or as high as 0.91 GB/$ (newegg). So, you could already pack a drive full of it + a battery (and optionally enough NAND to hold a snapshot of the DRAM) for less money. Okay, size and power might be a problem, for now - but, we've been promised die-stacked DDR5, enabling DIMMs with capacities up to 1 TB.
The other thing is, yeah Optane has crazy write endurance. However, to equal a 100 DPWD Optane SSD, you just need a NAND-based drive 10x as big that can manage 10 DWPD. And it'll be cheaper. Or, do the DRAM thing I mentioned and get like 1000 DWPD.
No matter how you look at it, Optane was out of rope. If you can't scale it, the economics just don't work.