Mr_Orange - mk4 silver 1.8T

[Mr_Orange]

Reasonably happy motoring since the spring. Have done a few miles this year.
Started to notice a bit of hesitation and stumbling under load, got worse last week and forced me into a bit of spanner time and routine maintenance. Code for N75 open circuit, found connector not fully engaged (?), thought I'd solved it but no.... New spark plugs, changed maf for my spare, cleaned TB, checked everything tight still no dice. Unplugged maf, nope. Resorted to changing out each coil pack for known good one and finally found iffy one on cylinder 4. Its driving like new again!

[Mr_Orange]

Odd one with CCM I've more or less identified but not sure how to fix.
Interior and puddle lights intermittently work or not. With door open and no lights I get a feint door open warning on dash? Took the plunge and dug away kick panels to get at CCM. Touched the wire harness and puddle lights came back instantly. I've proven it dozens of times now, just not sure of a fix?
With battery disconnected I've connected and disconnected that plug over and over again incase it was a dirty connection and no change... But once it happens next time, give the harness a wiggle and lights operate again.
Fault within cable?
Error within CCM, dry joint?
Bad contact crimp in connector?