Honda had a design problem with the automatic transmissions used with the V6 engines in model years 1998-2002. There was an unrelated problem with the same transmission in 2002, when thread lock was left out of a crucial area. Other than that, Honda automatic transmissions have been good. The 4 speed auto in my daughter's 1993 Accord (4 cylinder) is going fine after almost 150K miles.
www.hondacarforum.com