Using dumb cables avoids one of the issues (configuration channel pins shorted together), but not the other one (sourcing power even when the configuration channel says it shouldn't source power).
That is, the workaround is both "use only dumb cables (which use only one of the CC pins)" and "never connect to a USB-C device which might source power while the rpi is being powered by something other than the USB-C".
> "never connect to a USB-C device which might source power while the rpi is being powered by something other than the USB-C"
Wouldn't this actually apply to a lot of use-cases of the project in the linked blog?
The whole point is connecting the RPi as a peripheral of a laptop, i.e. a power-sourcing host. if you do that, you'll also likely be tempted to use an external power supply for the Pi as the USB's supply is limited. It's important to note that this will lead to problems.
That is, the workaround is both "use only dumb cables (which use only one of the CC pins)" and "never connect to a USB-C device which might source power while the rpi is being powered by something other than the USB-C".