Are you using a purchased custom cable or maybe you made your cable yourself? I'm asking this because I recently dived into building custom coiled cables and I also experienced this issue.
I later found out that it was a bad soldering job made by me on one or both of the connectors that was causing the issue. I removed redone the soldering on both ends and it works from there.
Note that when you see this error (USB accessory has too much power), MacOS disables the port in the Mac. So when doing a fix, you need to use a different USB-C socket in your Mac, there should be more than 1. It sometimes needs a restart for the OS to reenable the socket/port again.