With all due respect. . I need and want SSD speed and for those that have 2.5gbe+ home network, they probably do as well. My next stop is 10gbe or 25gbe, but that's another topic. Those running databases/VMs/AI and other rapidly changing data sets should stick to HDDs and/or enterprise solutions.
360TBW / 3 years is and arbitrary value set by Samsung and is a reflection of a business model non-technical people at Samsung can understand. I have absolutely no idea how that is derived nor do I know how accurate it really is. In my opinion, it's simply something that make business sense to them with respect to risk (an important concept that their EVO line taught them).
260TBW is the warranty that Sabrent offers on their micron QLC Rocket Q drives. It's likely wrong as I have been torturing a Sabrent Q that is just shy of 260TBWs with no bad blocks or use of reserve blocks, read errors or write errors. However, the programmable remaining life parameter has been 0% since ~120TBW. I will not stop torturing this drive until I see an error or a spare block used. 12 DWPD and still going.
100TBW is the warranty that ADATA offers for the SU630 256GB drive with QLC NAND I stopped writing to one that passed the 300TBW mark just because I was anxious to move on to another test and drive writes were far too slow. Again, no errors and 100% of remaining spare blocks untouched.
Speaking of slow writes from large data, Yes, QLC NAND can be really bad. A lot of DRAM-less stuff I have seems to fluctuate between 80MB/S to 120MB/s . ..if not for the noise, I'd stick with HDDs. TLC seems to fair better at 120-250MB/s. I have not tested my MLC stuff as I don't see the point right now.
When I manage to see errors on the Sabrent Q drive, I'll move on to a Crucial MX500 (maybe).
Charge trapped flash has come a long way in the last several years and there really isn't a lot of data to support the warranties stated. It's arbitrary and part of whatever business model vs risk manufacturers come up with. It's highly probable that they perform their own in-house write-to-fail testing - if they do, they are very shy about sharing data. I read an article once where a Toshiba engineer stated that modern CTF memory will hold data for a minimum of 10 years unpowered. JEDEC wouldn't hold him to that, but how would you test it? There are general specifications for writes to CTF and for QLC, that is 1000. My personal feeling at this point is that you should absolutely be able to get 1000TBW on QLC NAND before you start having issues.
I said that endurance may be far lower than drive specs leading to a warranty replacement, however, it's my firm belief that endurance is far, far above what companies rate their products.
You say that one should hunt for used enterprise drives (I assume SLC or MLC). Perhaps true, but risky and very, very expensive. You will need to buy/build something capable of NVME SSDs at 15mm NGFF or SAS 15mm. Not something most are willing to do, IMHO. Racks are generally very, very noisy and for most that want to use SSDs - it's the noise they want to get rid of. My focus is on consumer grade stuff that will fit in an off-the-shelf NAS or something home-grown and that means SATA. I'm sure there are plenty of people who have the space and time for an enterprise grade rack solution, but that's not me. Most people are not running a data center and do not need the level of TBWs offered by enterprise level drives (not to mention the power and up-front costs). I just want to save my data quietly and with as little power as possible. . .that means SATA SSDs. Samsung is the only option right now. 4TB drives only means that you use twice the power and need 2x the drives for the same storage. You don't save (much) money by buying generic brands and reliability is likely negligible. You will spend more for 4TB known brands to reach the same level of storage capability.
4TB TLC Crucial SSDs are more expensive and come with a 1PB warranty (less than Samsung's 1.44PB for 4TB QLC). Why? They are using TLC in that drive that should be good for 3 PBW! It's arbitrary. I'll stick with 8TB right now. Unfortunately, that means Samsung.
I think PTC NAND will come out by 2Q 2023. Won't that be fun!
All is my opinion based on various articles on NAND flash memory over the last 10 years of publication. (and my limited testing)
If I'm missing something or you feel I simply don't understand, by all means. . please educate me. I love to learn. I'm nearly finished my "Frankenstein" 8 bay NAS. Just need 4 more 8TB SSDs. . .