I've used Amphenol connectors and can't argue about the quality and reliability, but they are expensive and heavy. The weight can be a factor if you putting the connector in a run between two locations and not at a bulkhead, firewall, or, in your case fastened to the transmission pan. For your application, I would use the weatherproof
Packard connectors. I've had good service and good prices from Waytek. These connectors are very reliable and I've used them on different vehicles under the hood and under the chassis. No problems from gas, oil, water, dust, or anything else.
What ever connector you use, I second the advice to use a good crimping tool to connect the wires to the contact pins.