It really sucks that this phone is perfect apart from the charger port
In general I'd say usb-c is considered far more durable than micro-usb. But as always, tolerances vary between products.
Dip both plug and socket in water, sand, pocket lint, soil, and cat fur.
Plug in cable
Wiggle a bunch, tug the cable in a few random directions.
Disconnect, then repeat the process 10,000 times.
If the plug and socket still work correctly after that, then it's a good socket design. If not, it is insufficiently robust and the designers should redesign.
Using my MacBook's USB C cable requires constant checking that it's still connected - could just be an extra "feature" Google added.
it's up to quality and brand, ie. whichever top notch one will serve well and be very durable, as money never lie