Darktable should already basically do all of this with their existing copy and import function. The only thing it won't do is erase the SD card for you, and generally I would recommend you just format it on the camera.

This seems like table stakes for photo library software. Apple Photos does this perfectly on Mac and iPhone. i want more powerful capabilities but I'm not willing to sacrifice UX ¯\_(ツ)_/¯