Originally posted by: dud
The problem that I've found with that generation of Accords (I have rented them A LOT) is that they are VERY boring cars to drive ... but on the good side they are very reliable.
Problem must be behind the steering wheel.

It's a family sedan, not a Lotus, but the Accord has a dual personality that kicks in when you hit the backroads and let the superb V6 stretch its legs. As Car and Driver mentions in most of their Accord reviews, there is a synergy to the controls, drivetrain, and chassis that make it much more satisfying than you would expect based on city driving. There's not a whole lot of "personality," but they are predictable, communicative, capable, agile, and forgiving. That last sentence could easily describe any modern Porsche (though I don't pretend to compare them). They placed the regular previous-gen V6 sedan above the Mazdaspeed6 in their last sport sedan comparison.
OP, if you are looking at automatics, I would give you a caution. The V6 automatics from that generation (and the previous generation) were not really up to the task of handling the V6. Though they are clairvoyant, smooth, and quiet autos when they are working, my first failed after only 65,000 miles (replaced under warranty). The service internal for fluid changes is 120,000 miles, yet it barely lasted half that long. This problem extended to nearly every V6 car Honda made for a while, though things have improved with the latest cars due to a better design. Anyway, I'd really recommend the 6-speed manual if you're looking at 2006 V6 models. If I had to go back, that's what I would have bought instead of the auto. For the 4-cylinder, the auto will be just fine if that's what you want.