PSA: if you're having RPi SD-card-corruption issues, get a higher-amperage power supply (the official power supplies work well). Low-voltage warnings are a telltale sign.

SD cards are indeed a really bad deal when it comes to reliability, especially if like me you tend to slam raspis everywhere almost as a reflex: before you know it, you end up with a large-ish fleet of the things in your house.

But: Raspis these days work 100% fine with SSD's, and while a small SSD is not yet as cheap as an SD card, it's not far off.

I have entirely stopped using SD cards for my Raspis for quite a long while now.