The double row keeps it smaller is maybe a matter of opinion. I don't see 6 pads SIL as being any larger than 3x2 pads footprint. Maybe 5x2 is something. I've put 1x5 headers places where 3x2 would be a tighter fit; probably need to make the board bigger, in fact.
The pins are long enough to ensure alignment before contact - this is a good thing.
In fact, they're wayyyy longer than necessary for that.
I have never used a redundant header but not sure why the tag-connect would make that any harder.
Because it's a double row... If you make a proto board with a pluggable connector, you have to route this double row twice. A SIL row can be multiplied as many times as you want without any extra routing/vias.
I have the captive pcb adapter to hold it in place for development.
You got me here. I didn't know this existed. For my protos, I either add an extra pinheader. Or I hand solder a connector onto my row of ICSP pads.... which is all the easier if it's SIL and I don't have to refer to a library footprint or a diagram.
Making my own.... simple reasons.
1. Replacable pins. You can slip out worn out or bent pins and slip in new ones. You can select different pin heads for different purposes. In case there is flux on the board, you can use the spear head pointed ones with a higher spring weight. If you accidentally forgot to remove the paste layer on your ICSP header (oops!), you can use serrated head pins on soldered pads. Etc.
2. Remappable. Sometimes I switch the pinout to save space on a board. My custom interface has a couple rows of pads where I can swap the pinout. I have even made a few custom interfaces with asymmetric pin spacing specific to a pcb, to allow gaps for simpler routing on the pcb.
3. Ergos and/or interface to a jig.
4. Button. You keep mentioning this button you have to press with your other hand. I press the button that is on my ICSP interface. Because I'm an electronics engineer and I make things operate the way I want.
5. Positioning... much easier to position SIL row of pads without guide pins. I've done hundreds if not thousands of boards with Tag connect by hand and by arbor press. I've done thousands with an SIL pogo pin interface by hand, by CNC, by arbor press. I hate Tag connect with a passion. Guide pins are not necessary. It's the asymmetrical guide pins and the straight up/down positioning that it mandates combined with the ergos of the interface which make Tag Connect a pain to use by hand. My interface is shaped like a pen. You can see what you're doing. You can make fine adjustments to position. I would rather my surgeon use a scalpel shaped like my interface than to use a little blade on the end of a small plastic nub where he can't see what he's doing and can barely make a proper, repeatable adjustment even if he could.
6. It's way easier than you think. No CNC router or 3D printer necessary. All you need is a pcb layout. I solder the pins holders flat to a pcb. Two pads per pin. Reflow one end to straighten the pin.
7. No matter what lengths it comes in, I bet the Tag Connect cable is still a relatively inflexible piece of telephone cable with an RJ connector. No where to access/tap those traces for other purposes. No way to change the cable or connector without surgery or a clunky adapter; and no way to secure your solder connections and/or affix anything to any part of this interface other than with heat shrink, hot melt glue, and wishful thinking. It's an HDPE nub connected to a rubbery vinyl telephone cable. No place for screw holes. No flat spot to mount it in a repeatable fashion.
I simply put the PCB on a piece of ESD foam if it is being programmed on a flat surface.
This is fine if you're the guy designing the board and flashing one of them. Even this piece of foam is annoying when all you want to do is slide the next pcb over and flash it. And finish the 200 boards that you are no longer impressed with and just want to get off your plate.
The 3 alignment holes are small
No matter how small you make a hole, there's still a minimum distance between the edge of a hole and a trace. The smallest hole in the world is an obstruction almost as large as a via. And it's on every layer on your board.
For high volume flash, the best is to flash the chips before you assemble the board. I have an amazingly simple solution for that without handling chips. No sending my firmware to a third party or paying a premium or planning for lead times.
*If Tag Connect is so great, why do even their distributors not use it? Microchip promotes and sells Tag Connect through Microchip Direct. I have purchased Microchip dev boards. I have 3 different Microchip programmers. I have never seen a Tag Connect footprint on any of them.
I am sure they get a really good price on these Tag Connect interfaces.
There's only one place where I don't dislike Tag Connect. That's when the board is already installed in a tight location that is difficult to access. When you eventually get the Tag Connect guide pins in, you're home free. (If there's enough room under your board for the ridiculously long guide pins, of course!)