Normal Remington "525 Bulk Pack" is what I shoot in my Sig Mosquito and 5" .22lr upper. So far, it has stayed subsonic 100% of the time. The action noise is what you gotta deal with. The other thing that will make some noise is the "first round pop" phenomenon. I'm guessing since there's air (containing oxygen) in the can before/as you fire the first shot, it contributes to the combustible gasses. I could be totally wrong on why the FRP happens, but I know it does. My Mosquito with an Outback-II is pretty quiet shooting the Remington standard velocity bulk pack because it all stays subsonic; but that first shot is definitely the loudest.
You could potentially use a "household cleaner sprayer" and very gently moisten the inside of the can; I'm guessing that would bring the sound signature of all the shots down quite a bit. I sometimes use a little wire-pulling gel in my Osprey 45, but I've never tried any ablatives in a rimfire can. Usually, folks will tell you not to use them in rimfire, or if you do, use a tiny amount, due to most rimfire can's small internal volume.
That pistol/can combo sounds kind of like a nail gun or some other air-powered tool. Without the bullet going subsonic (assuming you've got a can on there), it just doesn't sound like a gunshot to me. With a .22 pistol, if you can grip it right, you can hold the slide shut, thus minimizing any action noise; takes practice (with gloves) though. My 10/22 eats Remington subsonics all day and they seem to work great. When they are out and digging, I regularly get headshots on gophers out about 80 yards or so. They'll pop their heads up just enough to peek around for a couple seconds, which is all it takes... I'm fortunate that I live in the country, so there's nothing behind my targets that I don't wanna hit. I'm not sure if I'd try it in a residential neighborhood though. I do, however, know somebody that bought a rimfire AR and uses a can and subsonics to cull his local feral cat population, and he lives in a neighborhood... He reports that nobody has ever asked him what the "noise last night" was.
cheers, Benji