I really like the Lightning connector, it's by far my favorite connector.
It does seem like with USB C both the plug and the port are fragile. The plug can easily be crushed and the port, like Micro USB, has the weird plastic tab with pins that can be smashed. That being said the only mechanical failures I ever witnessed with a Micro USB Port were when a cable was forced in the wrong way, I would definitely chalk those up to the user (ex-mother-in-law) being a supreme idiot and not necessarily a flaw in the port.
> Lighting also does a nice "click" when connected.
All of the USB C Cables and devices I own give a very nice thunk when plugged-in, almost like going over a speed bump in a car. There's no question that a connection is made.
I think the biggest issue over all is dodgy cables and I had my fair share of those with Lightning and Micro USB. I've only bought ISB C cables off Benson Leung's recommended lists so I have yet to get a bad one yet though I have no doubt the problem is as bad or worse than with Micro USB.