I was able to come up with my own measurements to answer this question. I remembered that I had a device called a "Kill A Watt P3", that plugs between an electrical outlet and an appliance plug. It can give real time power consumption data. I plugged my Apple 96W power adapter into this and my 14" MacBook Pro with M1 Max, 64GB of memory, and 24 graphics cores (i.e. a nearly maxed out system) and took power measurements:
Battery 100% charged, power readings varied, the ones below are the peak powers observed
Lid closed. 5 W
Waking up, screen 50%: 14 W
Screen off: 9 W
Screen 50%: 11 W
Screen 100%: 18 W
Single core GeekBench 5: 24 W
Multi core GeekBench 5: 53 W
Battery 5% charged (i.e. fast charging)
Awake screen 50%: 96 W
My tentative conclusion is that even a maxed out 14" MacBook Pro should operate fine with a ~60 W + supply. Obviously fast charging will be limited by the power supply. There will be power transients that a device like the one I used will miss, but the battery should handle those fine if it has any charge at all. This means that it is likely that a pass through hub limited to 60W or one of the travel sized GaN 66W USB C supplies, should power any 14" MacBook Pro.
I hope to test this soon, or hear from someone who has.