Aisin O9G Tiptronic / TF-60 is the good 6SP Auto trans that came in the New Beetles and pretty much bullet proof.
Owner reviews for automatic transmission
The automatic is doing fine. People have been tuned stage 1/2 since the MK7's release a couple years ago.
Nissan has had huge problems over the last 15-20 years with their transmissions. Nissan has sourced automatic transmissions for all of their front-wheel drive or all-wheel drive models for the past 20 years from a company called Jatco, known for making awful transmissions. They're notorious for failure, especially when not religiously maintained, and cannot be rebuilt when they do fail, forcing Nissan owners to buy an entirely new transmission when theirs fails.
Auto oem trans will fail. Only major pitfall in terms of long term reliability.
The transmission itself is not going to fair well with a significant power increase as its a very fragile automatic, even by Hondas terms. I would imagine your automatic would moan and groan even at that point, and your transmission would probably buckle after a short period of time afterwards.
Write your review about automatic transmission
Help others - share your experience with this part.