Oh yeah, so there is an easy and cheap remedy, let computers handle cable data connections the same as smartphones, asking for consent.

That would mitigate the danger for charging with an 'unknown cable'. But when you actually want to use it for data, the issue will remain.