Stock:
I like the 6th gen. body style, and especially the coupe,
then the 7th gen. next, for h.p.
With wheels and a drop:
7th gen., then 6th gen., then 5th. I saw a charcoal 7th gen. sedan one day at work with 17" wheels and a nice drop (about a finger width) It looked on par with a beemer.
One thing I like about 5th gen. Accords is that the body style still looks reasonably up-to-date for how old they are.
The 4th gens. seem a little too Civic-ish to me now since Accords have gotten bigger, but they are still great cars.