Ahh, connectors. The single practical area of electronics where there are always five further, unseen levels of enlightenment to obtain. Just when you think you have it figured out, another revelation. Truly an interesting area of study, especially if you have heterogeneous electromechanical design requirements, a budget, and both supply chain and assembly process are in scope.