If you have some sort of external I/O you could use it with a bootloader to program the firmware in system by having the bootloader preprogrammed.
Some chips with USB hardware (ATmega32U4 for example) come with USB bootloader by default!
I know what a bootloader is, how it works, and why I might use it for a project.
But, once again, how is even the concept of a bootloader relevant to the search for TQFP clips?
Many, if not most embedded applications, don't use bootloaders (Arduino weenies excluded). Even if a bootloader is used, that doesn't change the need to probe the chip.
Back to the OP question, any sources or recommendations for TQFP clips?