* SLC - 1 bit per electrical cell
* MLC - 2 bits per cell
* TLC - 3 bits per cell
* QLC - 4 bits per cell
You need SLC cards if you really want something to be long-lasting. You can find some at specialty places like Digikey, or labeled as "Industrial" in normal channels (i.e. Amazon sells both Kingston and Samsung 8GB industrial cards).They are both smaller capacity and more expensive, though.
Also, if you're using a stock distribution not intended for a Pi, you probably have quite a lot of logs/etc churning, which can be cleaned up. If you aren't doing much with the Pi except a few common services, check out DietPi.
The solution I found was these ATP micro SD cards (looks like the prices have increased like 3x though...) where the firmware is specifically designed to tolerate abuse:
https://www.digikey.com/en/product-highlight/a/atp/industria...
Perhaps there are other cheaper but still robust alternatives now?
I've had a Pi Hole running on the same microSD for 6-7 years now with only one hiccup (and that was a software thing - a fresh install got it back up and running on the same microSD). It just has a regular SD card (not a high endurance one), but the power supply came from adafruit, and it's been connected to a UPS for most of its life.