Transmission choices
 

Hey guys I'm in the market for a 2010-2013 S4 or S5. While I'm looking I was wondering which transmission I should be considering, or if it matters.To about what horsepower can the manual or auto take and still be reliable? In the end I'd like to have something reliable yet manage 0-60 times in the mid to low 4 sec range.
Thanks