If you do decide to give the pi another chance, move the root partition to an ssd and avoid the SD card woes. Or, boot from a USB device and have no sd card at

If you do decide to give the pi another chance, move the root partition to an ssd and avoid the SD card woes. Or, boot from a USB device and have no sd card at all on the Pi 4. Both work well and a cheap option as you probably already habe all the stuff. You've still got a load of wires to deal with though (unless you shell out for a fancy case).