Hi and welcome to the BBS.
I thing your choise should boil down to what exactly you want to do with your air pistol.
A CO2 multishot like the 92FS is great fun if you want to empty a 10+ magazine in a few seconds, peppering a "soft" target like a soda can or CD case.
On the other hand, if you want to fire single, aimed and more powerful shots, then a single stroke pneumatic/springer is the gun for you - in which case the Beeman P3/P1 would probably be your best choice. Pneumatics tend to be more accurate - "recoilless" - while springers tend to be more powerful, but with a bit of a kick.
I own both types of pistol, I find I tend to use my HW45 (P1) more frequently, to blast miscellaneous objects to smithereens with a single shot. - the CO2 multishot is more of a tension reliever or a fun toy when you have friends over for some informal plinking.