sounds like people simply weren't taking any care of them, that's why they broke. If they had cases and decent sd cards that probably wouldn't have happened.
I’m responsible for a fleet of a few hundred Raspberry Pis being used as home monitoring hubs - they use high grade SD cards, and are configured to write as little as possible while still fulfilling their function, yet we still see one or two a month fall of the internet because of SD card corruption. This is absolutely a problem.
I believe the compute module is somewhat better in that it uses eMMC rather than SD cards.
Same interface as an SD card, but better firmware and probably higher quality flash. SD cards are really aggressively cost-cut, often coming in than less than the price of raw flash of the same capacity.
As someone who has also worked with fleets of devices (R.Pi-based and others) working off SD-cards, I can confirm what jon-wood is saying. For some reason SD cards fail at a much higher rate than eMMC flash chips in traditional SMT packages.
I was under the impression most non-awful SD cards had some sort of wear-leveling these days but there's no standard for it so they don't advertise it on the front like SSDs. I couldn't really find any proof either-way about this, just a few instances of people looking into it:
I think every microSD and USB sticks by now has WL across the board, especially at awful grade. WL and ECC are must at current [price, BER, capacity, bit-per-cell] or something.
It does look like there are many of cards that don't claim any sort of wear leveling (doesn't mean they don't do it at all but they don't call it out). This is surprising to me, but if you want to make sure you get a card with wear leveling, look for it in the specs. These SanDisk industrial cards[1] are ones I've used in the past that specifically claim they do wear leveling in the spec sheet:
Advanced memory management FW features power immunity, auto/manual read refresh, ECC, wear leveling.
They're also only a few bucks more than a "normal" microSD card.