Is the transmission on the 1997 Accord weak?

I posted this question here before and someone told me that the tranny for this year is rock solid and they weren't bad until the 6th gen with the 5 speed auto; however, I asked a master mechanic of 46 years what he thought and he said that the tranny in the 97 accord is weak as piss.
Come on you honda accord enthusiasts. I need your help. I keep hearing conflicting opinions. Is the transmission okay on the 97 accord or not?

I'd love some feedback from some owners of an accord from the 5th generation!

I believe they're good actually. Problematic years was on 1998-2002 accord, Odyssey vans, worse with the v6.

Do a automatic transmission fluid exchange on your car and take it to the shop for check up