Although it's not a traditional frame pump, I love my Topeak Road Morph G.
With the hose, the pressure gauge, and the foot stand, it works like a floor pump but it's not much wider than a regular frame pump. I'd be curious to see how the weight compares to an older silca, my topeak weighs 205g. It comes with a bottle cage mount that can also be mounted anywhere on the frame with the included rubber pads and reusable zip-strips.
I've used traditional frame pumps before and they can be frustrating sometimes, I'd imagine a bit more so if you're a significant distance into a longer brevet, so the improved ease of use might be welcome.
Also, I'm not that familiar with CO2 systems, but if you're already planning on taking a pump as a backup, why not just ditch the CO2 and use the pump all the time?
Edit: just saw your comment about looking for something that looks great, so that's probably a point against this one.