Hi AdamLa,
I am having the same exact issue as you've described on my A3 2017.
Car has never gone into limp mode though, I've been on the motorway at normal speeds with the light flashing the entire journey. But as you've described, car turned off at work and restarted 4+ hours later on the way back from work - doesnt illuminate.
Next morning it does illuminate again.
Although heavy acceleration always seems to bring it up whatever the conditions.
Fault code is Oil Pressure Switch related.
Did you manage to fix the problem and what did you need to do? Was it simply changing the switch?
Please please tell me it was an easy fix 😁