No handgun cartridge can guarantee a stop unless a CNS hit is made. A small caliber can do this almost as well as a larger one.
A heart shot is not always immediately disabling, nor is a lung, liver, kidney shot.
Pain will stop most people from doing whatever it is that got them shot. Fear of dying will make people stop most of the time. A good CNS shot will shut them down immediately.