But that's just me and my anecdata. Whether SSD or HDD, you need a solid backup process anyway. If you have that, then I'm not sure it makes a lot of actual difference either way.
And I would repeat it again, you need years of 24/7 writing to hit the claimed DWPD. If your SSD fail in less than 6 months then you got a faulty product in the first place, hard to extrapolate it to the whole tech.
With that snark, have you RMA'ed or replaced the SSD? Have you tried the drive in another motherboard or perhaps an external enclosure connected over USB? Have you validated the firmware is up to date? And a brief search for 'samsung 870 bugs' yields a thread on failures of this particular model. [1]
[0] https://arstechnica.com/gadgets/2022/09/five-years-of-data-s...
[1] https://www.techpowerup.com/forums/threads/samsung-870-evo-b...