[pnoye2]

I would get that leaky sunroof taking care of first DRD before proceeding... then look into the TCU, with that much water inside your vehicle hopefuly other components under the floor carpeting didn't get toasted.

How long ago did you clean them solenoids and drain/fill with fresh ATF??? maybe just another series of cleaning and drain/fill with fresh ATF (preferably honda ATF) is just what it needs... otherwise, I'd take the tranny shop advice and start looking around for a replacement sorry!

 

[pnoye2]

The transmission is strong, I doubt it is bad, it just picks the wrong gear for the speed.

I'd double check your shift linkage and throttle cable to see if the shifter cable and throttle control needs adjustment... hope this helps, good luck!