Al Gerharter wrote:
Then there was the Air Transat from Canada to Spain, that developed a
fuel leak, and the "automatic" system sent all of the fuel
into the leaking tank trying to balance the aircraft.

It wasn't the automatic system. The pilots made the conscious decision to
transfer fuel from the left tank to the right tank, despite transport canada
regulation that on etops aircraft, preserving fuel in the wing with the
functioning engine was paramount.