CCI cranks out quality ammo, and they have a wide selection. Most of my .22 lr firearms perform best with CCI Mini-Mag ammo.
We do the best we can with what we have. As I enter the autumn of my life, I often reflect on which handgun I will ultimately be able to shoot best if recoil should become a problem for me. I've seen friends and colleagues who have had to quit shooting because of such things as arthritis. I may be in the early stages in my support hand.
I own 3 twenty-two caliber handguns. One is an antique (1908) Iver-Johnson, 8 shot revolver with 6 inch barrel. It has a very long and heavy double action trigger, but firing single action is manageable.
I also own a Sig Arms Mosquito. A very accurate and dependable pistol when cleaned and lubed properly. A joy to shoot.
Finally, I own a NAA Mini-revolver, with both .22 lr and .22 magnum cylinders. Being such a small pistol, the NAA would not be my first choice as it can be difficult to shoot accurately. The model I have has no rear sight, and there is a lot of pressure loss due to the extremely short barrel (1-1/8"). It's what my neighbor calls a "Get the f**k off of me gun."
There has been a lot of development in .22 ammo lately, mainly in the magnum loads. Ammo makers are loading magnums with jacketed, controlled expansion bullets, such as Speer Gold Dot, Federal TNT and Hornady Critical Defense. I expect they will be making some long rifle loads with those bullet options before too long.
In my personal unscientific tests, I have fired the magnum Federal rounds that expand to about 9mm and penetrate about 12 inches of water and the Gold Dots with a bit less expansion, although still impressive, with 15 inches penetration. I haven't had a chance to shoot the Hornady stuff yet, but I like their design concept. The jacketed bullets blossom nicely as they expand, unlike the lumps-o-lead we see in traditional .22 HP bullets.
Ask anyone who scoffs at the lowly .22 if they would like to be shot with one.