In a similar vein, I discovered and have started using the Tag-Connect TC2030-USB to program/troubleshoot my boards. While it's technically/originally intended as a way to do JTAG debugging, I am completely enamored with the ability to drop a footprint on my PCB and be able to connect to it without having to place a relatively expensive connector (or a connector at all) that I don't necessarily want users interacting with.
https://www.tag-connect.com/solutions-target-devices/usb-ser...
They have FTDI versions as well, for those who want the full USB boot/reset treatment.
Also, they have another connector for attaching to castellated edges. I think it's just so clever.