So then what should they have accommodated and what should they have left out? Should they have dropped backwards compatibility? Should they have made different connectors for every use case? Those are the exact problems which caused USB to become popular in the first place!
It needs more simplicity.
Like the rasp issue - the cables marked active work while the ones not don't. Or vice versa? I don't recall. Never seen any such markings - but apparently there is a distinction there that some how interacts with raspberry not having enough capacitors.
^^ See that paragraph of confusion? That's what standardization chaos looks like. Neither I nor apparently raspberry foundation know whats going on.