I'm no expert, but what I've heard is that the auto box is generally reliable if it receives an oil change (every 100k or so IIRC). And the manual is expensive if you need the clutch / DMF doing.
Personally I think that engine suits the auto box well.