Earlier quoted context omitted.
Not my experience with commodity SD card, power supply and stock settings of Raspbian. They must be using some "secret sauce" to make them run 6 years without outages. I would suspect some industrial grade SD card (SLC or at least AMLC), high quality power supply (e.g. UPS with surge protection) and also some way to limit writes on the SD-card.
Any disk-IO heavy application will brick a card in record time. I worked on a lot of Pi-based systems at my last job (long term time-lapse photography) and we learned quickly to: 1. Buy high quality SD cards 2. Remove as much disk-IO as possible, using an external USB stick for raw data storage, logs, swap, etc 3. If you really need to make it stable, make the OS read-only
Aside from USB sticks, any ideas on alternative storage suitable for RPis (something small)? I know you can get eMMC modules that fit into the SD card slot, but I would have guessed they'd have the same issue with writes.