Mini pumps aren't much better for road tires, if you are wondering. I use CO2 cartridges. Wasteful, I know, but I don't use that many. I bought 16 a few years ago and still have one or two left.
Those big frame pumps were pretty nice. I still have my old Zefal hpx. I considered making it my pump for my gravel bike, but it's pretty old, and who knows what condition the rubber seals are in, so I wasn't sure I trusted it.
Some friends have those battery pumps, and I've used them twice. They seem fine. Over the long run, likely less trash than CO2 cartridges.