My experience with SanDisk has been mediocre. I've multiple microSD card failures in GoPros and RaspberryPis. Their microSD to SD adapters are the absolute worst and their cards, an only theirs, will continuously dismount and remount every 30 seconds or so if left idle in my laptop.
Sony has let me down as well, their cards have either poor or no wear leveling and will die in a matter of weeks when used in a GoPro. Every single one I bought has died inside of a year.
The longest lived microSD card I currently have is from Lexar and I recently bought some Samsung cards to see how they'll do.
The better-known brands like Sandisk and Sony have a ton of counterfeit clones in circulation. Some of the problems you are experiencing might well be due to that.
Lexar is a less-known brand, less likely to be used by counterfeiters.
My personal record is an 11 year old 1 GB Lexar that's even been thrown into the washing machine by mistake a couple times. Still in use. I find these things extremely resilient in general, no issues with SanDisk at all for me.
I refuse to buy SanDisk. Have had multiple microSD and USB flash drives from them that are permanently stuck as Read-Only. According to them, it is a common manufacturing error in their process.
Sony has let me down as well, their cards have either poor or no wear leveling and will die in a matter of weeks when used in a GoPro. Every single one I bought has died inside of a year.
The longest lived microSD card I currently have is from Lexar and I recently bought some Samsung cards to see how they'll do.