The pi form factor is fine, but 2-pin Molex-type connector in parallel with the incoming 5V would be a great addition. Hell, even just leave pads or holes and I'll solder in a connector myself. RPi's are being used more and more in embedded applications. It would be nice if the Foundation acknowledged that and made it a bit easier to work with.
However, I disagree that the Molex connector is inherently superior to USB-C. I am abundantly familiar with the incongruity of a wall wart in an embedded application, but all you need for the power supply is 5V delivered over a USB-C connector. I understand an appeal for a latching or screw-secured connector, but a pin header connector is neither of those. USB-C doesn't easily fall out, it's just another connector.
Another answer is to hack a USB 2.0 C-C cable [1] in half, pull back the shield, heat shrink over the shield and 30 AWG data wires, crimp ferrules on the 26 AWG power wires, and run those to my screw terminals of the existing embedded 5V power bus.
Molex has very sturdy through-hole power connectors as well as plugs that are lower profile and won't torque off the connector as easily. 2-pin Mini-Fit Jr. would work pretty well.
Or XT30 even. I love XT30 connectors.
https://www.amazon.com/JSER-Type-C-Locking-Connector-Standar...
Issue solved.
https://www.raspberrypi.org/products/compute-module-3-plus/