There were a very few problems with the 6's tranny a few years ago when
high mileage was reached, leading to a recall and installation of a kit
to keep the second gear properly cooled. The 6's transmission has no
other issues, and current models, at least '04 forward, were slightly
redesigned to fix the problem.

The nearly same transmission is used in the MDX, where it tolerates a
3.5 liter, 265+ horsepower V6 (whose origin is in the 3 liter Accord
engine). It does fine, so it should certainly handle the Accord's
power. I would not avoid the 6 due to transmission concerns. Change
the fluid regularly and don't let teenagers drive it, and it will
almost certainly be okay.