Welcome the the same story i had with many programmers, i have/had : mcumall gq-4x, tl866, avr isp, avr mk2, avr stk500, avr dragon, freescale programmers, stm32, microchip pickit 2, pickit 3, Xilinx dlc9 interfaces / programmers etc etc .... the list goes on and on.
When i managed to find the TNM-5000 and the Elnec programmer i was happy to dicover the front 20 pins idc who can became jtag isp and other interfaces, They do almost 95% of all my needs, I still have to rely on old rs232 interfaces, even an old parallel port programmer.
Even myself i could be wrong about many adapters on the market, i saw what we call standard adapters sockets using different pinouts to create troubles if we buy other brand of adapters, some companies tells wich types of adapters we can use, others don't, we have to rely on them.
And they use this as a way to charge lots of cash to buy what we need. Even the cheap tl866 have some "eeprom Id's" on the socket adapters pcb's to make them genuine in the software ??
It was a nightmare to "evolve" from 32bits to 64 bits machines at my job ....... and we still have to use an windows Xp machine for tests purposes, there is no updates from the interfaces we use in it, its obsolete.
Now when we develop our boards we try to have a long lasting and future supported technology, we use programming interfaces connectors for all the chips we use, our very old machines have obsolete Xilinx chips, we had to replace old XC9572XL cpld plcc84 pins with an atmel atf1504 put on a small pcb mimicking the xilinx pinout, but the interface programming connector on the pcb still serve its purpose, we did lost an "not to used often interface", some clients complained, but when told how much an "technology revised / upgraded" version of a new board would cost, they changed ideas loll
A good zif socket can go from 20$ usd up to 200$ and up $
You have very specialized programmers, many sockets who can go up to huge bga ic's ... the list never ends, frustrating and time consuming to say the least.