@rhesusminus the first part of your comment is what I was hoping might work. I wasn't aware it was the DCL file that I was looking for but thank you for checking that.
If I'm understanding, I believe what you're proposing is to add this info into the USER fields in the Create/Edit Wire Type dialog. That would work but we would have to be very careful about which wire layer we select when routing wires. For instance we have several spots where we use 14AWG BLUE wire, some of which use different connectors, some of which use none, some of which use connectors only on one end of the wire. So we would have to have a layer for each 14AWG BLUE/CONNECTOR configuration which could get confusing.
I think my current situation is more appealing but it can also be confusing. I've set up a report format file and renamed the W01USER-W03USER fields to CABLE, CONNECTOR 1, CONNECTOR 2 but of course this doesn't go back and update the dialog screen. I think our engineers will simply have to know that W01USER=CABLE, W02USER=CONNECTOR 1, and W03USER=CONNECTOR 2. Aside from that confusing tidbit it should work fine. The only other concern would be which component you select first when routing the wire. I realized that for reporting, when two components are placed and a wire routed between them. The first component placed in the drawing equates to CMP1 on the report and the second equates to CMP2. Makes sense right? So when a wire is routed between them and the W02USER info filled out (which I've renamed to CONNECTOR 1) you have to route the first end of that wire to the first component which was placed for CONNECTOR 1 to match with CMP 1 on the report. If you route the first end of the wire to the component which was placed second, the text input into the W02USER field (CONNECTOR 1) field will not match up with CMP 1, it will match with CMP 2. Super confusing, I might just say we need to keep a very close eye on connector info on the report to ensure nothing is off.
I'm still learning so maybe there is an easier workflow I'm not aware of.