I think I've settled on this approach ...
It solves the cable attachment problem, uses a through hole usb connector (which is also clamped in by the connector strain relief clamp), and overall is a lot less fiddly to put together ... takes about 30mins or so. Plus you now have your choice of cables/lengths to use.
I do need to respin it once more as the pcb width going through the cable outlet was slightly too wide, not helped by the round rather than oval holes on the usb connector footprint, so it needed a little filing.
So ... cost breakdown:
PCB | JLCPCB | £ 1.70 |
MCU | CY8C4246AZI-L433 | £ 5.90 |
Programming Header | 2x5 1.27mm AliExpress | £ 0.07 |
GPIB Connector | (Aliexpress) | £ 1.96 |
USB Connector | 651005136521 | £ 1.00 |
Fuse | MF-MSMF050-2 | £ 0.42 |
Diode | MBR0520L | £ 0.18 |
Caps (3) | 2x1uF, 1x0.1uF | £ 0.06 |
I've allowed £1 for the USB connector, I'm using ones that came in a AliExpress "selection" which clearly will be much less than this, the footprint I've used is the 651005136521, but you don't seem to be able to buy that anywhere that I can find.
The PCB's cost a total of £8.50 for a batch of 5 the vast majority of which is shipping costs, so £1.70 each -- clearly this reduces if you order more. If you only want one, then clearly you're going to have to pay for a batch.
All costs are either what I paid or current Farnell or Mouser costs and include UK VAT, I didn't particularly look for cheap fuses or diodes, I just used the ones that were used in one of the dev boards.
So that's a grand total of £11.29 ... so not quite under £10, but not far off ... and a far cry from anything else you could buy (and a lot more compact!)