You'll want to get the car inspected by a trusted mechanic. The $100-200 an inspection often costs can save you THOUSANDS and lots of your time, that alone will narrow down your choices a lot.
As for advice specific to older Hondas, watch out for bad VTEC solenoid symptoms, bad engine mounts, faulty power window switches, bad head gaskets, timing belt condition and rust.
I might be missing a few others but that should have you covered. Hondas from that era are generally bulletproof and the odds of you running into serious issues are low.
Any specific Honda models you have in mind?