Past Pi's verses current Pi's.
My first embedded Pi was an old A, still works after 6 years and only SD card corrupted twice.
I have only an anecdotal suspicion from back in the early Pi days.
I noticed with old Raspbian back then I had more SD card failures on model B's 5 years ago.
I suspected and still do suspect that any Pi connected to a network failed more often, sometimes it did so within 10 minutes.
What happens in Linux when they are networked I have no clue and no big incentive or skill to find out.
Backing up all those Raspbian 8GB cards for each project required us to get a backup server.
This was unsustainable so I went looking for a smaller OS and found PiCore, a TinyCore Linux spin for Arm cpu's.
PiCore boots and run on a ram drive, pull the plug and the OS is safe, might lose some data but after 4 years not a single one has crashed.
Raspbian and Linux has changed much since then, I won't say it is bullet proof but it is ok for desktop type use.
I will not use it for embedded myself but Pikrellcam uses Lite and my external usb drive camera installs have not crashed for 2+ years.
But I have had to swap the SD cards on the non external drive Pikrellcam as the vids and thumbs are saved to the SD card.
This has been required less as I keep updating to latest versions, they seem to be getting more reliable
The hardware has also changed, the original Pi's had linear voltage reg's the new ones have switchmode regs.
Again anecdotal, I feel the SW regs on the A+, B+ etc add more protection against power glitches.
MicroSDs are physically more rugged, lots of my cheap and not so cheap full size SD cards fell apart after years of use.
The reasons I am moving on from PiCore to Ultibo is from a security issue, OS size and Application Lifetime Management issue.
I don't need General Purpose OS for my embedded apps, a single purpose OS is fine, with the advantage the app is only KB's .
A UPS would be my next step, but to protect against a now very small failure rate, not sure if it is worth if for my stuff yet.
None of my stuff is of critical use, if it was, I may not be using Pi's, not that I would trust my coding skills either
I do intend to do solar powered Zero's one day, these will have UPS stuff in them and perhaps industrial SLC based SD cards.
Not sure what else can be done after that? Different memory technology?
For Raspbian Desktop use on Pi3's, another option is now within reach, SMI based IDE drives.
Would IDE SSD's be the best solution? Same IDE drive or SATA or M2, in USB caddy?
I don't fully trust USB sticks, had lots over the years, some have failed, but then so have IDE drives.
Comparing to rotating PC IDE HD?
Well at least you can pull apart HD's and get useful stuff from them, I have lots of stuff
Drink coasters, mirrors, super magnets, 3 phase motors......
What were SD cards intended for, running OS's?
Are we pushing them to their limits?
I suspect some of us have bumped up against early failure modes and gone way past that.
I personally found it a weakness years ago, found solutions and learned a lot in the process.
I no longer regard it a weakness but an asset.