If you want a fun car, and not a daily, don't bother with an Audi S3 or RS3. Fast, secure yes. Fun? No.
I had a S3 saloon manual. The only positive for the manual, is it bring some interaction with the car. I enjoy changing gear, so I'll always pick a manual over n Auto. And fun doesn't mean it...