Personal experience and mileage may vary, but I have used USB-C across many different devices (Galaxy S8, Pixel 2XL, Pixel 3, Pixel 4XL, iPad Pro 5th Gen, Razer Blade, PS5, Sony WF-1000XM3, etc.) in the last several years and have never had any issues with a loose connector or inconsistent charging while plugged in.
Also while working in cellular sales/support for the last seven years, I find it far less common that clients come in with charging port issues on USB-C devices.
Just yesterday I spent several minutes unclogging a lightning port (a common occurrence) which had been so jammed full of lint and dust that the iPhone simply would not charge anymore. Not to say this sort of thing can't happen to USB-C, but I've come across it far less frequently in my line of work.
Like it or not, USB-C is here to stay for the foreseeable future, and having a universal cable that is compatible with a wide variety of products is really a pretty great win for consumers in the end.