Read the techpowerup review of SN770. Dram is not some magic bullet for all ssd performance related issues. It is kind of like how a latest dual core intel pentium can blow a 7th gen core i3 out of water. Latest NAND flash coupled with latest controller having improved algorithm on a dramless ssd(SN770) can match/exceed older gen dram ssd(like 970 evo plus) in almost any area outside of sustained sequential write speeds scenarios which will likely never be encountered by 99% of typical pc users. Also, SN770 has been one of the most solid/reliable ssd in recent times. One more thing, TBW is just fancy marketing so never made the mistake of assuming that because a drive has 2000TBW then it will always be better than a 1000TBW drive in similar capacity. That "feeling" you are talking about is same you will get while using SN770(again, read the TPU review). It's unfortunate that SN770 still commands so much premium here when in US it is a clear winner below only top of the line gen 4 models like 850x.
TBW is the brand's guarantee that it will work to that limit. I assume a Seagate or WD or Samsung wouldnt claim a number just for the heck of it. And if they were sure it would last more they would claim more. Proxmox is really heavy on the writes. Their forum reccomends enterprise drives which have 4-5 times TBW and have PLP, but my data would be backed up dailly locally and the cloud, so I dont care that much, its just a VFM thing. Lets say in 3 similar drives, this ticked all the boxes. Same performance, lower price, 2x tbw. What's there to not like.
As for Dram, let me end by saying this -
I get what you're saying.
Do I need another pair of hands? No.
Is not having another set of hands stopping me from doing what I want? No.
Will I still take an extra pair of hands if I can get them and they're in my budget? Hell yes.
If you like that model, then go for it man. I can pay a little extra for critical stuff. And for stuff thats not critical, i can use the most basic stuff too. I am not contesting that its a good drive. Now that you pushed it so much , I might even consider it if there is a good discount and I need one. Im just saying I have a particular order of preference dictated by how NAND actually works, no amount of hacking your way with the controller will change the basic physics of NAND. But sure the newer tech will compensate with other better things.