Whenever I would notice a cable not working (after about a year and a half), the culprit was always dust buildup inside the Lightning port preventing the plug from entering fully. Clean it out with a toothpick for 15 seconds, and then good as new.
If you were using an original Apple cable, that's bizarrely bad luck. I can't even imagine what could physically cause that.
My mother goes through cable like candy. I'll buy a pack of 10 and give her 8 and I won't even be done with my cables by the time they stop working.
My wife has used apple for years, while she does need new cables from time to time the phone side has never had an issue.
I also have a phone with a broken USB-C port (data signals don't get through). This phone was effectively bricked when the display stopped working. It still has files on it I'd like to read, but I can't read them because the USB-C data on it isn't working to use remote debugging, and also means the HDMI out feature doesn't work.
I have another phone where the USB-C port works but its charging is intermittent, probably because it isn't making a reliable connection. Probably due to matter accumulated in the port, as the connection does feel slightly less solid than it should be, but it's a pain to clean it out. A toothpick is slightly too large. I've tried various methods of cleaning it out but the problem persists, and I wonder if it's really matter in there, or if something is wrong with the metal parts inside.
These are just my anecdotes, and I don't have anything that uses Lightning to compare with. But I have read claims that USB-C is a very robust, long-life connector, and my experience doesn't give me as much confidence in it as those claims suggest.
Every other one Apple has fixed for free as some internal solder has failed.
But that was twice in about 50 cases.
(I do free/volunteer tech support for old peoples homes)
An example of the issue I found searching the issue real quick: https://www.thetechmentor.com/posts/fix-lightning-cable-burn...