I replaced an aging Toyota Corolla with a gently used 2001 Accord. I read that there were problems with the V6 trans so we steered clear of those and got a 4cyl. We were deeply disappointed when the transmission on the car went out at 139000 miles. It was the same failure that the V6's had. We also had the dreaded EGR valve issue and spent weeks tracking it down and getting it fixed. I currently drive a 1992 Chevy S-10 that has been far less trouble, and far less expensive to maintain, than this supposedly "reliable" Honda. I don't want to curse all Hondas because I know they had a bad run, but if we had it to do over again we wouldn't have bought it. And it's soured me somewhat on Hondas.
Comfortable to drive long distances.
Go back to a more reliable transmission. Lower road noise.