I have used 45 ACP (revolver and pistol), 45 LC (revolver), 357 (revolver) and 10mm (revolver and pistol) for pins with cast and JHPs in search of the perfect pin gun over the years. 10mm with 200 grain Hornady JHPs going 1200fps are just the ticket. They will sweep the pins off the table into the next county.
I found that 357 would often go through the pins and just knock them over. 45s with 200 to 255 grain bullets going fast enough to a good job would beat the gun to death (broke the lugs off several semi auto barrels - moon clipped revolver was great though) and 45 LC was too slow to reload but was a great pin gun.
From observation 38 spl, 9mm, 38 super are all very marginal unless you are a very, very good shot or there is a special table with the pins set at the back for these calibers. 44 spl also appeared to be a good pin load but too slow to reload and 44 mag was good too but most people using them would load them too hot and they were either uncontrollable or the bullets would just go through the pins. The 44 mags were also a slow reload.
Photos of my current 10mm pin guns a slab comped M610 and a comped Colt Delta Elite.