Yeah, after you've had this problem once it seems you'd uncheck delete after import before buying a literally entirely new photography system.

My workflow is don't delete after import but format the card in the camera afterwards. I have XXXL cards and it is not such a problem if I forget to format.

I had one case where I screwed up a shoot and thought file corruption might have been involved (it wasn't) Even though I had formatted the card with the camera and shot maybe 5 test shots I was able to recover most of the images with Disk Drill

https://www.cleverfiles.com/data-recovery-software.html

which has both Windows and Mac versions and looking at a sample of them confirmed it wasn't corruption, it was user error.

Or just treat the SD cards as write-once and keep buying new ones