Wouldn't the various computer Youtubers be all over this stuff? e.g. LTT, Gamers Nexus etc
I don't think they have the in-depth knowledge to talk about this. They are mostly repeating press releases.
Can't blame them though. They are journalists after all.
You can buy enterprise disks, eg: Micron. I mean for example the Micron 5400 as max type supposedly has "Up to 23,827TB" TBW.
Or if you want to go really fancy, stuff like swissbit. You will feel that though, at >€1 per GB.
But I don't think an embedded windows is going to wear one out though. Maybe it's not worth the price.
Our industrial pc vendor fits oem Phison as far as I can see on the invoices.
I have seen some SSD failures in the field on our machines, but I don't think this was due to the flash being worn out. I suspect mechanical failure of solder joints. You could monitor it with HD Sentinel if you want.
Anyway, if you buy larger there are more spare blocks?
Regardless of promised quality,
they can still fail, please do backups. Not only to cover hardware issues.