I assume one of the problems here is that you don't use an USB-C to USB-C cable in combination with using the "USB controlled by this device" mode.
"USB controlled by this device" should be equivalent to what was called OTG with USB2/Micro USB. At that time you could not use OTG with charging at the same time.
In the USB-C era it should be possible if the ...
most of flash tools have a "reboot after flash" option. here is example for Mediatek devices
install VCOM preloader drivers
open scatter file with SP Flash Tool
add new entry for EMMC_USER (with start address and size of boot partition) at Read back option
click readback (start)
connect phone (readback will start as soon as ...
Yes an no.
Some years ago this was a very severe security problem, as a lot of devices automatically enabled the MTP mode when connected via USB that allows to access all files in the "sd-card" section. Also some device had ADB enabled by default.
Nowadays MTP and the other file-access protocols provided by Android devices are usually disabled by default ...
Sorry, you can't do it the way you intend to.
Google photos can back up to Ext.SD, only if the card is treated as internal storage. In your case the SD card is not treated as a part of device memory (portable) .
Adoptable-storage is applicable only if the card is actually mounted on the device and not when connected via USB connector.
Many PCs can be woken from sleep mode via a keypress. Some, if configured to allow "wake on LAN", can even be woken via a specially-composed Ethernet packet.
I'm unaware of any way to force an Android device to power on using a special USB command.
What to try
You can try removing and reinstalling the battery.
Or you can try connecting the ...