We aren’t technical so can’t follow your advice
The hub light turns red then purple then after a couple of hours on the back up returns to blue
Does the hub connect to the phone socket or does it connect to a box on the wall with lights on it? (What Licquorice meant be an ONT). If it connects to a box on the wall with lights, what are those lights doing?
The OP states they have full fibre , if that’s the case then checking the ONT during these periods is necessary to try to determine if it’s an Openreach issue affecting BT or just a BT one , although they also say Openreach say the network is fine (although how the were told that isn’t mentioned) .
FWIW , my SH2 on FTTC has started dropping out and restarting probably around every two days , no specific time of day , it just drops and comes back up randomly, it’s a pain but not sufficiently so to call and complain about it .
My money is on the ONT to Hub cable. If it was the hub restarting the Hybrid Connect wouldn't be able to kick in.
Or a poor splice causing the light level to the ONT being on the cliff edge.