Looking at ssd for speed and longevity, eh? Go to ebay or whatever secondhand marketplace you prefer and shop the used enterprise u.2 and grab a m.2 to u.2 adapter while you’re out. You will not find a better value for your dollar if endurance is an objective. Datacenter grade storage is more expensive but that’s because the endurance is rated in drive writes per day instead of terabytes written. For example,you can roughly expect prices to be 10x higher while endurance will be 50x higher when comparing enterprise ssds to consumer.
Hopefully the lifespan scales with the amount of writable space. Would be even cooler if that factor was improving over time. Any studies or articles on the topic?