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.
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.
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.