Reason I ask, I'm wondering what the actual use-case for said tethered plug is these days and why they are still on the cables in today's world.
Here's why:
Some video cards have 6 Pin PCI Express power connectors and others have 8 Pin PCI Express power connectors. Many power supplies come with a 6+2 PCI Express power cable which is compatible with both kinds of video cards. The 6+2 PCI Express power cable is made up of two pieces: a 6 pin piece, and a 2 pin piece. If you put the two pieces together then you have a full 8 pin PCI Express power cable. But if you split the connector into two parts then you can plug the 6 pin part into the older 6 pin PCI Express connector and leave the 2 pin part unplugged. That way, your power supply only needs to have one 6+2 cable to be compatible with both 6 pin and 8 pin PCI Express connectors.
Compatibility is the reason of the pigtail.
In similar sense, this is also the reason why CPU +12VEPS cable is 4/4-pin and not full 8-pin (for the most of the times). But there are PSUs out there who's +12VEPS power cable is also 8-pin (solid connector, without being able to split it in two).
How much power does the main 6+2 provide and how much additional does the tethered 6+2 PCIe cables provide?
6-pin PCI-E power cable is able to provide 75W.
8-pin, including 6/2-pin (if pigtail is connected) PCI-E power cable, is able to provide 150W.
Pigtail contains two additional grounding wires, which in turn essentially double the Amperage rating of PCI-E power cable (from 2.083A to 4.167A) and thus, double the wattage capacity as well.
To add to that, +12VHPWR connector (in use with RTX 40-series GPUs);
2x 8-pin -> +12VHPWR = 300W (for powering RTX 4070)
3x 8-pin -> +12VHPWR = 450W (for powering RTX 4080)
4x 8-pin -> +12VHPWR = 600W (for powering RTX 4090)