I don't know anything about the S4, I just went sniffing for videos to see what they do. I reckon auto, it doesn't have the 'dive' you'd associate with a manual changing up on the strip, looks pretty seamless.
GIAC reckon they've done an 11.8 in a manual, but that'll be American 1/4 mile. So downhill, with a tailwind, with a sail, and a running start, and ......
Snag a drive of one, I was very impressed indeed. Feels RWD, which is very odd for an Audi, you can slide it around and it never feels nose heavy.
I'm guessing there's about 400kgs difference in that and yours, maybe more? You can't beat physics!!