For what it’s worth I’ve bumped into similar strangeness in 3 different homes. Intermittent cross failure of two ceiling lamps in Castle Duffer; son’s top floor stair lamp; and sister’s fridge/freezer and oven. All in older properties, and nothing to do with new-fangled technology!
Root-cause was loose connections. The length of wire available was on the short side, making it awkward to get wire ends into terminal holes and be sure the screws had gripped properly. Pushing back into the mounting stressed the wires making it likely they would loosen, and I’m sure alternate heating and cooling of the connection over time does the same.
The Copper in my son’s ancient Red, Black, Green wiring made it even trickier to seat and clamp the wire correctly in the terminal. It’s noticeably harder and springier than the modern Brown, Blue, Green/Yellow stuff. Another mystery – why should his old wire be hard and springy? I don’t believe undisturbed Copper hardens with time, or that anything other than pure Copper was used to make it. Presumably son’s wire was work-hardened during manufacture and then not fully annealed, perhaps deliberately. Not fully annealing would reduce cost, or maybe springy wire is somehow useful.
Didn’t help that these fixtures were so close to the wall/ceiling that I had to check connections with a dentists mirror. I cursed the original installers: much easier to make good had they left the wires 15mm longer!
Reminds me of the German Battleship cock-up, I think Tirpitz. During fitting out much of the ship’s wiring was pulled tightly into the terminal boxes, which looks neat and resists vibration. The work was done during a hot summer. followed by an exceptionally cold winter, In the cold, thousands of wires contracted enough to cause gazillions of intermittent faults. Long delay whilst the ship was rewired…
Dave