SD and microSD cards are designed to be used in battery powered devices. SBCs are not battery powered. If anything, they are microSD card torture devices.
Basically 99% of the time, card corruption has nothing to do with the microSD card in question and more to do with the quality of your power supply.
Do you have any concrete evidence of the type of power supply being the culprit?
My personal feeling is the write patterns of Linux distros and filesystems are way more punishing to the card when compared to write patterns done other use cases. For example most writes done by digital cameras are fairly big and sequential, and done on FAT/exFAT where there is no journalling.
Yeah, whenever I read about someone having problems with microSD cards it turns out they use a sketchy power adapter.
I use exclusively the official RPi adapter with SanDisk cards (the standard ones, not any fancy variants) and had exactly zero problems.
I've been running them many years (8 highest) on multiple RPis, no special settings to make the system read only or anything. Numerous power cut offs (esp. when that's the only way how to power off or restart on the older Pis). Zero issues. I even had one RPi 3B+ failing (random lockups after some time), yet the microSD card from it was fine.
I’ve had multiple SD cards fail with official power supplies. My Pi4 now runs on a USB SSD, while the current SD card in my Pi3 (music player) so far has been going for over a year knocks on wood
Basically 99% of the time, card corruption has nothing to do with the microSD card in question and more to do with the quality of your power supply.