FWIW my pi-hole server ran for 2 years and broke 3 SD-cards, and it didn't even have the courtesy to fail fast, it started kinda-failing and DNS requests started taking forever (the pihole had to time out twice before the fallback DNS was called).

Moved to an Actual Computer with a M.2 SSD and zero issues since.

That's likely with constant power and low writes. If either of those flip for long enough, bye bye flash.