Third party USB Ethernet adapter won't wake up
You cannot allow the Mac to sleep. That is the fix. If you do, just make it standard operating procedure to unplug and re-plug. Been using Mac Pro's for music production for many, many years. This is not a problem, it is just how they work. Same as you can't hibernate a Mac, and you can't wake one up from LAN.
What seems to work on various systems (sometimes)is to have a Mac USB Keyboard directly connected to the computer and then have your items connected to the keyboard's ports. You need a powered HUB for you can't draw power from the keyboard.