Lightning females are basically eternal for all intents and purposes even if they do feel a bit looser at the end of the terminal's lifetime by eg letting water into the connector part itself.
I don't know that it is any worse with USB-C as all usb-C devices I own are far more sheltered from everything.
USB-C is still welcome though because all other types are barely pluggable into a compatible device.
But to be fair I've also had many issues with Lightning. A few shorted out and became unusable and burnt on one side. And those were 100% original bought in the Apple store, as were the 5W chargers and iPhone this happened with.
Knockoffs were generally terrible and might stop working. A "genuine" cable bought from big retailer turned out to be a knockoff once after a software update, resulting in annoying popups from Apple. And some knockoffs were so bad they didn't stay in.
Even certified Mfi ones from Belkin somehow felt different, like the tolerances were slightly off. Those worked though.
Overall, I think it's had a good run and was underrated as a connector physically, but on the whole I like USB-C and it's more open ecosystem more.
Now, HDMI, on the other hand... yeesh
Apart from that though it was proprietary, which is awful for lots of reasons; that’s the main reason I’m happy to see it gone.
50% failure is an admirable and lofty bar that all electrical connectors should strive to meet.
Lightning is so awesome and universal that Apple has never even bothered fitting it to a pedestrian device like a computer, and has reserved it for only their most very-exclusive, high-tech devices (like the portable telephones and mice that were once available at astutely prestigious retail locations such as Wal-Mart).
Seriously, this Lightning connector is like the best Kool Aid ever. It's a shame that they stopped making it; it could have been everywhere, if only it had more time in a truly free market.
12 glorious years was clearly not enough time. It deserved so much more.
And by the time you revise the pinout, you effectively have a different connector. Lightning was nice-ish to plug in, but the wear-component was on the expensive device, not the cheap cable, and pairing it with the shit data transfer rate makes it a terrible connector