Okay so the magic sauce here is USBC-PD which is some type DC-DC voltage converter. Then it's just a matter of barrel connector roulette to find the appropriate plug for each device.
I live part time out of an RV semi-off grid for some of the year and the "using AC/DC power packs off an inverter" always struck me as super dumb which your data basically confirms.
What you've given me is a roadmap to figure this out without having to reinvent the wheel.
We can all think of at least five little shits from our early education who absolutely needed an age-appropriate beating to make them into people fit for society