What years did the Honda Accords have bad transmission?

[pollo con agua]

I am look for a honda accord with a v6. I heard the transmissions were absolutely horrible. Does anyone know what years the honda accords had bad transmissions and if it was just automatic or manual as well.