The cable is not a dub set of wires; there's a a lot of silicon in the connectors. Though they fall back by default to the old resistor sensing used in earlier USB specs, the higher functions (which include power delivery) are negotiated.

As far as I know a universal cable is not possible. My reading of the spec says that it should be but I am not a USB implementor and some of my friends who are tell me it's not possible. In any case nobody ships such a thing.

The charging cables provided with devices are likely to be power-only. With the 87W charger, Apple ships ones that can carry about 100W (the maximum per USB spec -- 20V@5A) which requires thicker conductors; my understanding is that those cables don't carry data (i.e. they can safely be plugged into any third party brick without you worrying that the remote device will attack your computer). You want a power-only cable for this purpose. I am not sure of they have the same cable with the smaller adaptors.

The very high speed cables only work over short distances unless you go to optical (which I'm not sure anybody has deployed).

The most standard cables carry "USB 3.1" which is just another name for USB 3.0 carried over Type C connectors. The higher frequency and higher power cables are more expensive to design and build so will cost the customer more. That's one reason you have to specifically look for cables for DP, PCI-e/Thunderbolt etc.