Egads, yeah. There's so many use cases that no standard can accomplish all of them. USB-C tries, and even it failed to cover some pretty big use cases. If I were to try to list out qualities that a USB-C port could have, I can come up with several different features.
0. Base level. No significant power draw in either direction. No significant data flow in either direction. I'll label this as the USB-A solution.
1. Significant power draw, recipient.
2. Significant power draw, provider.
4. Significant data throughput, recipient.
8. Significant data throughput, provider.
Between these, there's 16 different combinations, and pretty much all of them exist. As an exercise, I tried to see if I could come up with reasonable examples for every one of them.
0. Every single USB-A device.
1. Phone charger, typical use.
2. Wall wart for a phone charger.
3. Rechargeable battery.
4. Monitor with dedicated power supply
5. Monitor without dedicated power supply
6. Charge a phone while playing video from it.
7. External tablet, currently in use streaming video from a Raspberry Pi, Raspberry Pi powered via the tablet.
8. Desktop graphics card.
9. External graphics card.
10. Desktop Graphics card powering a single-cord monitor.
11. External graphics card powering a single-cord monitor.
12. High-speed external storage.
13. High-speed external storage without a dedicated power supply.
14. First in a daisy-chained series of monitors, with a dedicated power supply.
15. USB-C hub
Which comes back to why there are no decent USB-C hubs, because every single port would be expected to be effective at every single task. Which is ludicrous, and strikes me as why there are no good USB-C hubs, because it's a Herculean task.
USB-A did a lot of things incredibly well (non-streaming data transfer, peripheral management), and a lot of things relatively poorly (device charging, video display). USB-C tried to improve on the aspects that USB-A was bad at, and made an absolute mess of the things that USB-A was good at.