Is this from a generic OBD2 reader or VAGcom? Everything else sounds like good detective work. My guess would be a bad coil. Red top coils for turbo cars are a little taller, but allegedly work better/last longer.
You almost hope the intermittent component fails so you can find it easier, unless it's a valve spring that is.
The QuattroWorld website is not affiliated with or endorsed by Audi AG or
Audi of America, Inc. AudiTM, QuattroTM, Avant,
Tiptronic, FrontTrak, A2, A3, A4, A6, A8, S3, S4, S6, S8, TT, TT-S, R8,
RS4, RS 6, Q7, Q5 and allroad quattro are trademarks of Audi AG.