Looks like, after further investigation, I have several, unrelated and purely co-incidental issues!
1. interior light cluster odd behaviour was a faulty interior rear light cluster. Replaced with a new one and it's all working fine
2. one-shot up/down function on rear electric windows was door frame alignment/sticky runners/dirty windows. Re-aligned and lubed runners and cleaned windows, all working fine
3. door not locking is actually a failed door lock. At least it's failed in the unlocked position so that entry and exit is still possible. The alternative failure mode sees the door being effectively sealed shut by an unlockable lock which requires surgery to the chassis to cut the striking plate out - yikes. Unfortunately A2 door locks are on back-order with Audi so I await a replacement. But people with intermittent door locking should probably start considering getting the lock modules replaced before they fail completely.