Honda:
Pros:
- More inventory, better chance of obtaining a good deal.
- Not first year model, bugs have been worked out.
- Well respected, well regarded as a solid performer
- AT is easy to service. One bolt to drain, one bolt to fill. (3 quarts of Honda ATF-Z1 each time)
Cons:
- Honda 5-speed Automatics, though they've been "fixed," are still questionable with regards to long-term durability.
- Accord is due for a redesign in 08, I believe. Thus, the product is nearing the end of its lifecycle.
Camry:
Pros:
- Latest redesign has "updated" the vehicle
- Toyota Aisin-Warner transmissions, recently, have been extremely reliable and there are many with > 150K on the road.
- Should be very reliable in the long run.
Cons:
- First year design, may have a few bugs.
- High demand, may not receive a great deal.
- Automatic transmission now takes Toyota WS, low-viscosity ATF. $42/gal at the dealer, no known aftermarket stubstitutes.
- AT is difficult to service. No dipstick, and must go through a PITA fluid fill procedure (pump in underneath vehicle) and a ridiculous fluid level check procedure. (Must monitor ATF temperature and remove check bolt underneath vehicle when running)
Your choice, but I'd go with the Camry, personally.
Don't overlook the 07 Sonata SE V6. You can buy one for the cost of a Camry/Accord 4-cyl. They aren't quite "there," but they come very, very close.