You sound like the kind of person who should lease. Just my $.02 though.
I've only driven 4cyl 03+ Accords. AT and MT and an Auto TSX.
I feel very cozy in the TSX. It also feels more solid as a whole IMO. I like the even more upright driving style than the Accord. You feel much higher off the ground than you are; which provides excellent visibility. The Accord for me has a bit more of a blind spot.
If you want a car that's tight, quick, and always wants more you need the TSX. If you're looking for a highway cruiser the V6 7th gen is right for you. (although I'd have a huge problem buying another version of the same car when a new model is coming out; you also literally only have days to get one as the new ones begin to arrive.)
I think the 2008 Accord coupe will be better in every way, and I'm not concerned about powertrain issues like the 03's had with their trannies, as the new Accord really hasn't changed a ton in that department.
If there are any big issues, I'm sure Honda will take care of it. They care a lot about their customers. My dad and my godfather both got the 03 Accord days after it came out. Both EX i4 Sedans in satin silver with black cloth. MT and AT.
The AT - 70k then traded in 2004 - No warranty work.
The MT - 56k as of today. - Radio replaced under goodwill, and SRS light comes on intermittently; but it's been in 3 accidents so I don't blame Honda.