The number that matters the most here is penetration versus what you intend to shoot. Although their velocity is impressive, when shot out of a 6" barrel Stingers may expand and/or fragment, which while absolutely and often visibly devastating against small varmints, results in inadequate penetration against larger targets such as humans. It should also be noted that some .22 LR ammo may counterintuitively be more effective against large creatures when shot out of handguns as opposed to rifles, and this includes the Stinger. However, ordinary, run-of-the-mill solid .22 LR ammo is more effective out of rifles, of course. If one is inclined to use .22 LR for defensive purposes against humans, then the CCI Velocitor is a superior choice because it should give adequate penetration when shot out of either handguns (since it will not expand) or rifles (along with expansion)--not many .22 LR cartridges will do this.
As for the terminal effects of .22 LR versus .22 Magnum, obviously the latter has a lot more velocity and energy potential, but much of that is wasted with shorter barrel lengths. I don't have many numbers regarding penetration available--mostly from the
Brass Fetcher website at other barrel lengths--but it's probably fair to say that .22 Magnum rounds out of a 2" barrel are more or less equivalent to hot .22 LR rounds out of a 3-4" barrel, and both should penetrate deeply enough (14-15" with no expansion) to kill bad guys. Out of a 6" barrel, .22 Magnum may be slightly more effective depending on whether and how much the bullets expand (too much can result in poor penetration), but most of the extra energy will go into a surprisingly (if you've never seen it before) powerful blast & flash rather than wounding the target.