One of my main concerns about the use of a raspberry pi as a desktop PC is microSD card write lifespan. microsd cards were not meant to be used as the boot disk for a live operating system. The amount of times you can write over one sector on them, and the write wear leveling algorithms, are much worse than even a $45 consumer grade SATA3 interface SSD. Yes you can now boot a raspberry pi from an external usb3.0 hard…
Judging by how often people talk about the feature online (or how often they enquired about the delay in implementating it on pi 4 - it's been possible with the 3 forever), a lot.
> something like the raspberry pi but with a socket to plug in a cheap M.2 SATA or M.2 NVME SSD is needed.
This is a not entirely uncommon but very badly thought out feature suggestion for the pi that comes from technical people who aren't the target audience and don't understand the target audience for the pi. It'd be an okay feature on the Pi compute module.
First things first, though: if you're really worried about storage reliability on these things (or anything), please stop prefacing your hardware suggestions with "cheap."
> low cost industrial/embedded/dedicated purpose headless machines, is from the microsd card failing after 6, 12, 18 months.
If you're trying to get this much value out of the thing, using either a legitimate, brand name USB ssd (not something cobbled together in a cheap enclosure), an industrial SD card built for embedded applications, or network booting are all good options.
Consumer grade sd cards are... cheap. It's not such a problem for a lot of the Pi's applications. I'm happy to use cheap sd cards to boot Pi 3s that serve as music players while using a Samsung T5 on the Pi that serves the music, for example (and on a development system).