I have the same issue with an iPhone and have been restricted to Qi charging only. CarPlay won’t work either because I can’t connect the cable. I bought a new iPhone as my (expensive) fix. I use the other one for testing (I’m a mobile dev) only now.

Don’t want to hand the device over to a repair shop and am too busy to attempt the repair myself.

If you fix it yourself, I would like to hear about how that goes. Good luck.