I took the car to our mechanic last week so he could look the whole car over and tell me if its worth getting the transmission fixed. He said that the car is in great shape and it only has two minor problems:1.)
One of the rear brake lines has a small rust spot that might eventually start leaking some brake fluid2.)
The seal around where the transmission/engine come together (I think thats where he said) is a bit damp and should be replaced only if I get the transmission work done.
There is not rust anywhere (except that small part on one of the brake lines) and nothing is about ready to fall off. He said it would be best to get a rebuilt transmission directly from Honda. This would cost $2600 + $400 for the labor, $3000. Advance Auto Parts sells re-manufactured transmissions for my car for $1700 + $400 for the labor to swap them out, $2100. He said that he would wait to get it fixed until it gets really bad. So I guess I'm going to play the waiting game