Edit: in fact, trying now it seems to be perfectly recessed that I can't even push on it from an angle with the connector, it has to go straight in a bit before it even touches, on any of my devices
I'll grant that it's robust in that it continues to work more than I'd expect, for example continuing to charge the laptop but not reliable for the external display. And once connected, sure it's secure.
I suspect it's not the cable mating that causes the failure, but other foreign objects… keys in the bag or something… that manage to dislodge it. And some laptops have more play in the connector than others, which I think allows the connector on the cable end to hit the wafer with an angle of attack sufficient to dislodge it. Some of my users handle heavy bulk materials all day and are anything but gentle with computers.
In any case, I'm sure the designers considered this, and far be it from me to second-guess their compromises. It is what it is. But if the port has failure modes, this is one of them.
I can emphasize with many of the gripes people have with USB-C cables and supported modes being confusing, but the port is really, really well thought out: Make the cable the part that fails more easily [1]; make it so that the plug only minimally acts as a lever while partially or fully plugged in; cover the pins on the plug (because otherwise people will inevitably touch them, and these cables can carry up to 48 V of voltage).
[1] That part has actually worked well for everything but my Yubikey :( USB-A and an adapter it is for the next one.
Alternatively, there are "brick nogging" connectors which stand up straight from the PCB and are therefore unusable for a Yubikey, or "sink board" ones which require a custom jig for assembly.
Meanwhile with USB-A you don't even need a male connector at all - just have a bit of your PCB stuck out in a vaguely USB-A-looking shape and it'll work just fine.
Why do you think that the wafer is the most fragile part?
One might argue that the latch mechanism would be the part most exposed to wear and tear due to mechanical stress incurred by plugging and removing. Those side latches are located in the plug, not in the receptacle.
See also figure 3-14 in the USB-C spec [1].
[1]: https://www.usb.org/sites/default/files/USB%20Type-C%20Spec%...
I haven't seen a USB-C cable that has wore out.
I guess I'll have to take a video next time I see it.
For people who are not versed in mechanical connector design it might look like the fragile part is that center wafer.
USB-A is massive compared to USB-C, that's why it's so robust, thick plastic, thick metal, wide connector lanes.
If USB-C is fragile, is just because it's so small, you can easily break it with not so much pressure.