The Raspberry Pi has a lot of weirdness happening when it comes to SD cards.

What will have happened is not a broken card - although it would be reasonable to expect people who've not had the experience to assume that it is. Actually the problem is that Linux on the Pi has knackered the 'partition table'. That is not overwritten by either the in-camera formatters or by the SD Alliance formatter.

I put it down to Linux being crap*. Linux on the Pi is particularly bad as it is very picky about which SD cards it likes and does not, without rhyme or reason. Even those on the 'working' list of cards may, or may not work and you'll have no way to tell in advance. I've been through half a dozen on the 'working' list and only one card works even though they're all fine on the testing tools in other devices. And yes it's Linux because if you take a card that fails and chuck RiscOS on it, then it's fine.

If you have a windows machine then you can fix it via Disk Management by deleting the partitions and making a new one. You'll then be able to use the SD Alliance formatter or a camera. I'm sure there's a way to get the partition table stuff via a Mac but I don't have one to hand to test any instructions on.

Note * That's consistently been my experience of Linux. Your mileage may vary.