No cons if you like burning money. Pros have been mentioned, and I'll add to them the ability to go 200+mph with manual TDI gearing.

The best bet at this point if you want a manual RS6, given the number of sorted swap cars done, is to buy one already done. Even if you have blown up your auto box, I'm pretty sure it's still cheaper to put in another auto box.