I think it’s useful to see how this is possible using only consumer products and software!

An alternative solution that’s less roundabout could be to use a uhubctl (https://github.com/mvp/uhubctl) compatible USB hub and directly switch the power of the usb port.