Therefore think this is probably a design fault with the connector, although it does seem that once it’s recognised
I can think of other possible causes:
heat
cold
bent pins
cigarette smoke on the USB port
oxidation of the USB port
loose wire on the USB port.
I have at least one USB port in the back of my desktop machine that I periodically have to touch with emory paper to get it to work normally again.