How can this 2xmolex -> pci 8pin be so terrible?
If it's the adapter that's hot, then likely there's a bad connection inside. This could be caused by corrosion, a loose fit, or just poor quality connectors. Since you say that there's charring and melted plastic on some of the connectors, I'd strongly recommend replacing them before your computer gets damaged or they start a fire.