The 03-05 V6 (AT) cars you can expect to replace the transmission or have it rebuilt unless someone was super serious about maintenance, and even then it might still go bad. Honda updated the transmission in 2006 I believe and those are longer lived. The filter is replaceable and should be done, even though there's no mention of it in the maintenance schedule. Same with the AT pressure switches.
Power steering pump O-rings like to fail. Usually, notice it in colder weather as foaming fluid and a pump making lots of noise. It's a $2 10 minute fix.
Motor mounts on the V6 cars. Not what I would consider failure-prone, but they do tend to fail after 100k miles. I don't have an I4 so I don't know if those are as bad, I suspect not as their lower power/torque engines probably don't abuse the mounts as bad.
The compliance bushings in pretty much all of them by now will be shot. If they haven't been replaced, expect to replace them. Might not cause driveability problems, but will cause tire wear issues on the front. More so in the heavier/more powerful V6 cars. You can replace the whole arm if you want to, but not with Mevotech. Moog works well. Or you can replace the bushings. My recommendation is to use an Acura TL bushing in it as it should be a little more durable as those cars were heavier.
V6 cars will need a timing belt between 100-120k. I4 cars are a chain. nothing to replace unless it is doing something odd.
All of them should at least have their valve clearances checked. Honda says 105k to do it, you're probably safe waiting till 150k or so.
Make sure the coolant is blue. Should mean that it always had the proper coolant in it.
If that list makes them sound like junk, far from it. They are solid cars. Those are just a few of the hot-spots to keep an eye out for that you can use to drive the price down if you want.
If its had reasonable maintenance over its life, they are good cars.