I'd recommend the CCI Velocitor or CCI SGB, mostly due to the characteristics of their bullets (in addition to the relatively good reliability of their priming). The Velocitor uses a hollow-point bullet, but it has controlled expansion and good integrity (exemplary for .22 LR), and will not expand significantly, if at all, at handgun velocities. The SGB has a flat nose and should have a similar effect, which if anything may be a slightly wider wound track than a round-nose bullet would create. Between the two, perhaps the Velocitor would be slightly more effective in a full-sized handgun, but with a really short barrel mostly it would be louder, I think (which may or may not be an advantage, depending on what you believe).
Slower, heavier loads like the Aguila SSS may work in some handguns, but then again they may not be as consistent--hardly ideal for defensive purposes. Lighter, faster loads like the CCI Stinger may work just fine for defensive purposes in some handguns, but there is a greater risk of bullet fragmentation and the underpenetration of large targets as a result; I've seen various gelatin tests that indicate good and poor performance, and personally I see no reason to take unnecessary risks. In my opinion, stick with quality 40-grain loads, like the ones mentioned above, in this caliber for defensive handgun use.