I settled on a WD Red SA500 "NAS" style SSD, potentially being commercial grade it ought to be designed with a focus more on longer life against higher "performance". Although the adverts say it is designed for NAS usage, if you look in to the details you find it doesn't have any of the unusual "give up quickly in event of a corrupted read" features a typical NAS drive does, rather it behaves just like a normal internal SATA drive. It is fine to boot (Linux) from. Another advantage was the type has never had any reports of needing firmware updates, none have ever been distributed, so it looks like they got the firmware of this Red drive type right first time, unlike the troubles they had with SA510 Blue drives, and unlike the troubles with various Samsung and Crucial models that wore themselves out fast due to firmware bugs which needed updates to fix them.
I do get the feeling though, that in the SSD market, the stuff built to the highest quality, apart from commercial grade SATA stuff, is all designed for putting in to systems that use NVME, often SATA SSDs look to be built with lowering manufacture cost as the primary design intention. This isn't a good situation when you need an SSD specifically to replace a 2.5" SATA HDD, as I did recently (I had a long thread about the struggle to pick the right sort).