Shame, those are nice cars. My Concorde (essentially the same car) lasted a long time. Never needed transmission work, not that it would've been an issue for me. I dunno what this nonsense is about their transmissions. I'll grant you, I've heard it from many people, never seen it myself. Sure, I've put transmissions in a few of those... but only a few. I've put transmissions in damn near every car. Let me tell you, I've done scores of Honda transmissions for every one of those I've done. And the ones I have done have had no problems, I can't recall even one of them even coming back to me. There are several other units that are prone to comebacks, but that's not one that springs to mind.
There are certain things in the automotive world that people get stuck in their heads that it's true. ie, Cadillac Northstar engines, Chrysler transmissions, LeanBurn, not being able to mix coolant types, using transmission fluid in the power steering, etc.
Honestly, I wonder how bad of a transmission mechanic you have to be to screw up an A604 (technically a variant), it's about the simplest one out there. I honestly couldn't tell you. Boggles the mind that someone who calls themself a transmission mechanic would say something like that. Far more likely they just didn't want to work on an older car, or were unfamiliar with that car.
Also, that transmission is very well computerized for something from the 90s. The computer is programmed to compensate for wear and tear, specifically with the intention of keeping it working as well as it could for as long as it could. So when it 'just' stopped, in reality it was probably going out for a while, but was being compensated for.