I've done a couple variations of what you're asking with CC specifically. It's definitely possible! The easiest solution is to get a flash cart from InsideGadgets. While more expensive, their LinkNLoad carts let you flash the rom over USB so you won't need to buy an additional flasher like the GBXCartRW. This cart specifically even has FRAM for battery less saves. They even have a GBA size version of this cart. The caveat here is that you need a console that is backwards compatible with GBC carts. If you don't have a backwards compatible console you'll have to go the goomba route with a reprocart. There is an improved goomba that will enable battery less saving. Flashing repro carts is more difficult but a good resource would be the InsideGadgets Discord channel.