12/07/2023
Well, after some hours of looking at damage pictures, some discussion and much head scratching, we've traced the problem, which is 90% of the battle - it's no good fixing something if it's just going to do it again!
But it looks like the spindle cinch nut had fatigued, preventing it from clamping up even when torqued - and managed to vibrate loose, and bearings adjusted right before the race - most probably from material fatigue on the aluminium.
Then it vibrated looser and looser until the locking/tabbed washer finally dropped out of it's slot and then that allowed the bearing to spin the nut off, which explains the whole lot suddenly falling off on the last 3-4 corners - and why the right side is fine, the right side would tighten itself while driving from the rotation, while the left loosens. And also why the thread is only damaged on the end of the spindle and was fine in the nut.
Which also means it's a fairly easy fix of switching them out for some stronger steel castellated nuts and roll pins to secure them, and not some sort of issue with the front hub/spindle/bearing assembly we'd previously got away with.
Unfortunately, because of the damage caused when it did come off, that means we need to machine and weld on a new spindle, sort new bearings, fettle a little bit of damage to the brake mounting bells and make new brake discs...so it's not all smooth sailing.
Onwards with the machine work I guess...