“However, the USB-C specification only accounts for a limited amount of kinds of cables, explicitly or implicitly excluding a range of cables that you might want to buy or make.”
Plenty of adapters people actually want are outside the USB-C spec. Some are harmless. One famously fried a Chromebook. The spec writers made a connector simple enough for anyone to plug in and complicated enough that nobody knows what it does.