USB has been plagued by many weird decisions and scope creep but I really hope USB-C puts an end to that. A fully wired cable contains enough twisted pairs for just about any application and the physical properties are great. Too bad manufacturers will keep creating non-compliant devices such as naïve hubs that don't account for PD voltage mismatch, or cables/chargers that claim to do something and actually don't, making it a coin toss as to what devices they work with.
The colors were chosen by somebody at Microchip but this has become the go-to picture for USB-C pinout. Here's the original PDF and here's a one-page vector version I made, you can print it as a poster: