The 5th Gen accord is a damn good vehicle no matter the trim, transmission or engine. I personally would opt for the 4 cylinder EX trim with a manual. The V6 is good but with fuel prices the 4 banger would offer a bit more economy. The EX engine has VTEC which increases power output by about 15hp while keeping mileage the same (if not better).

If you're all for the auto then go for it, there's certainly nothing wrong with them. But the manual will free up a little more power and is more fun to drive IMO. But again, this is preference.

You may want to consider upping to the 6th gen (98-02) Accord depending on your preferences. They get the same mileage but are larger and have a bit more power. There are plenty for sale in the 5K - 7K range if you're willing to go for one with over 100K miles. While catagorized as mid-sized sedans, the 5th gen and older Accords are really glorified compacts. If you really want a vehicle that 4 people could comfortably ride in then get a 6th gen. If you want a car a little larger than a compact but not quite as big as a mid-sized, then get a 5th gen.

As was mentioned earlier, if you get a 6th gen with an auto, make sure it has been taken care of. The auto's in the 6th gens aren't exactly the hallmark of reliability. Honda sort of screwed the pooch on this one. Some have problems and some don't, but the chance of you having problems with a 6th gen auto are considerably higher than in a 5th gen (where they didn't cheap out on the carrier bearings).