After having wrecked many MicroSD cards with ARM SBCs, I have found that the Samsung High Endurance MicroSD cards[1] have held up to consistent use so far, including being used as backing scratch stores / swap space for calculations on an ODROID-C2. They're also pretty cheap for how reliable they have been. Of course, it's just anecdata, so YMMV.

[1] https://www.amazon.com/Samsung-Endurance-64GB-Micro-Adapter/...

Get an industrial grade microSD indeed.

Swissbit is one of the brands who deliver such. But there are other options as well [1]. I evaluated a bunch of ATP cards and thus far I'm satisfied.

[1] https://www.digikey.com/products/en/memory-cards-modules/mem...

Yeah, even the name brand SD cards blow up for me after about 6 months. I've switched over to the Samsung "FIT" USB sticks that fit flush with the port, and boot off that. And leave the SDXC slot free for importing images from the camera.

So far, my experience has been SD cards faceplant by going read-only. They will mount rw, but a single write will cause a long hang, followed by a bunch of sd driver errors, and then it goes read only. It is still readable but will accept no writes, including blkdiscard (which gets translated into whatever the sd card equivalent for TRIM is).