Just saw the edit and if you don’t want to go the router route + LAN for some reason guess another option would be a ucb c dock that allows power pass through. I have an anker one that I use on occasion and recommend it. You can then either get an external drive or a SD card.
Yeah their MX series have been nice to me