If you do stick with a frame pump, the Topeak Mountain Morph works very well. It has a gauge, an extending hose, and a small foot rest (well, whatever that thing you stand on is called). I have less-than-optimal upper body strength but can still pump my tires to 100 psi quickly and easily. There's also a road bike version of this pump, which is slightly larger and provides higher psi. I use the mountain version because it was easier to find space to mount, and I don't pump my tires over 100 psi.

But, the more I hear about CO2, the better and easier it sounds.