a Kel-Tec P-32. It's actually pleasant, and it hits like a brick thru a plate-glass window.
In the world of James Bond, I think they have different bricks, plate glass windows and .32 autos than we do.
A word about pocket guns and small hands, hand size isn't the only thing to consider. Hand STRENGTH and the gripping area of the slide and its spring tension need to be balanced.
My mother was a small woman, 4'10" (and a half! damnit!
) and wore a size 3 1/2 ring. Dad got her a .25, an Ortgies, if I recall correctly (early 70s) and she could not load it. The stiff spring (blowback gun) and the tiny slide were simply more than she could manage. She could chamber a round with a Colt Govt Model (cocking the hammer first made it easier) and there was more slide area to grip. It wasn't the easiest thing for her to manage but she could do it. She just didn't have the hand strength to work that little .25 slide.
Had Dad gotten her one of the tip barrel Berettas (not sure if they were on the market then) she might have liked it, she hated that Ortgies.
Nearly everything mentioned in this thread wasn't on the market back then, be thankful you have so many options to choose from today.
My personal pocket semi auto is a WWII Mauser HSc .32ACP. All steel, other than the grips. Recoil is insignificant, its large enough for me to use adequately (I have larger hands, so the really small stuff works poorly for me) and while some people think its too heavy, I love the weight you can actually feel. Also the weight fits with my personal philosophy that in the absolute worst case, when everything else fails, your pistol is an impact weapon, and I prefer something steel with a bit of heft, for that.