Aside from being a fragile and poorly designed physical connector, the state of protocols that can be run over it is a disaster. My grandmother definitely will not be able to troubleshoot why her devices don't work properly together when she uses a USB type C cable to connect Thunderbolt devices. I suspect this will be the same for many other users.
While having a ridiculous number of different connectors isn't great, I think it would have been reasonable to at least have different connectors for power, data, and video (even if they were all part of the same spec, and just keyed different to help end users figure out what to plug in where).
I would also have really liked to see a solid core connector. Apple Lightning is a good example of what that would look like -- there is no tiny wafer inside of the device-side port to crack, and both the port and connector are much more durable. Not that I think we should all use lightning, but it's an example of a reasonably well designed connector in my view.
Finally, I think the fact that so many vendors have failed to properly implement the spec is a sign that it's a bad spec. Raspberry Pi and Nintendo presumably have competent engineering departments. By and large, nobody had difficulty getting microUSB right.