P06 Pros: solid, ultra reliable, very accurate, natural grip & pointing, easy to fire and easy to handle, easy to field strip & clean. Hammer fired, will discharge harder primers such as on military ammo, especially Israeli ammo. Pistol can be stored for years, cartridge in chamber, hammer half-cocked, in ready to fire condition. (My wife can't rack slide to chamber a round.) Comes with night sights. Excellent finish and workmanship. High resale value, if you should ever decide to part with one. PO6 & PO1 are most accurate pistols I have owned (of many). Alloy frame allows Crimson Trace Laser Grips and standard holsters, whereas polymer frame guns normally do not, which means they must use a front mounted laser and special holster.
P06 Cons: magazine holds only 10 rounds, and extends below grip, thus harder to conceal grip when CCW.
Comparison to some of your other guns: Far more accurate than Beretta M9/92/96. Much much better trigger than LCP, & much easier to handle. Just as accurate as SA XDM (I found all mine very accurate also).