There is some stuff to be learned, but especially with USB-C I’d say the vast majority are not labeled. There’s even some devices charged with USB C that can’t be charged with a PD charger and need an A to C cable. Phones are a great example where you have to look up the specs to know data transfer capabilities. Additionally they renamed the USB 3.0 standard which has been established for over a decade to USB 3.1 Gen 1 which is completely unnecessary and just serves to confuse. The standard was largely understandable with USB 3.0 generally being blue or at least a color other than black and on decently modern devices USB 2.0 would be black. With USB-C indication has just about gone out the window and what used to be a very simple to understand standard has now become nearly impossible to understand without having researched every device and cable you interact with.
As someone who’s accidentally punctured a large lithium ion battery with 100% charge I can tell you that explode isn’t exactly the right word. While I’m sure you could create an enclosure that could explode from the pressure, the battery itself just kinda shoots out a small jet of fire along with some toxic gas.