I think Bond went from the Beretta .25 to the Walther .380 PPK.
The .25 is a ladies gun unless you shoot someone in the head with it point-blank several times, like the Mossad used to do.
I understand that J.B. favored the .32 ACP Beretta, and was compelled to change to the .380 Walther by his employer.
The .32 penetrates rather well, and is not particularly loud, which can be handy attributes, especially if one uses it well, and can place precise shots.
After the RFK assasination, Time magazine published an article mentioning a particular .25 ACP shooting. A man was set upon in an alley, and beaten severely. He staggered to a hospital, where he was cleaned up and sent home. Several days later, complaining of headaches, he returned to the hospital, where he was then X-Rayed. They showed the X-Ray. 5 .25 caliber bullets in the brain.
I sometimes carry a Beretta 950 .25 for various reasons, sometimes only as backup when working. One should be aware of its limitations, and prepared for a colorful adventure, should it have to be utilized. I am always relieved when I put it away, faulting myself for not carrying my Mustang Pocketlite .380 when something small is called for.
IIRC the Mossad boys used the little 950 Beretta chambered in .22 short rimfire for the up close and personal executions they carried out on some of the kidnappers who killed those Israeli athletes at the Olympics in Germany. The .22 short has about the same power level as the .25 auto, but it's quieter and the soft lead bullet works better on brain tissue for the type of work the Mossad used it for. If you place the bullet properly so that it travels through the ear canal and into the brain even a .22 CB round will do the job.
I have seen my dad and my grandfather kill many cattle and hogs with a .22 short to the animals' foreheads at close up range. The cows always fell instantly like a ton of bricks from that one tiny bullet to the brain.