I think on the team @lifeeth, @curcuz, and @jviotti have some experience with SD cards, for different reasons (AutoHAT, lots of projects, and working with etcher, respectively), I wonder if they have noted down something yet? I remember hearing recommendations for industrial-grade SD cards that did work well, and remember also that the power supply is what affects the SD card wear a lot, but there has to be more than that…
From some internal discussion, apparently SanDisk Extreme Pro is the “best SD card money can buy” (paraphrasing, and it’s not an endorsement )
https://www.amazon.com/SanDisk-Extreme-MicroSDHC-Memory-SDSDQXP-016G-X46/dp/B008HK1YAA/