I switched to Samsung from SanDisk about 7-8 years ago (when I first discovered this cheating on one of my SanDisk USB sticks) and haven't had any issues.

BTW, there is no need to buy anything fancy for RPi, I just buy the cheap stuff, but I buy much higher capacity than what I need. Overprovisioning this way is cheaper and more reliable in my opinion vs. buying something more exotic.

For example for the most basic RPi install, I'll buy a 64GB microSD card. The card may only ever see less than 10 GB worth of data, but I know it'll last for years with plenty of chatty logs written to it daily.

Source: I've been running RPis from the very first version, and have never had a single card fail on me, ever.