As a rule, the best work on bullet technology has been done in the major auto pistol service calibers (9/357sig/40/45acp). In those calibers, even in a revolver, I stick with one of Doc Roberts' recommended loads. in .38 and .41, WC and SWC respectively as a rule. I do have a bunch of Gold Dot SB for my .357s and use GD in my .44 (M296).
A good SWC in most calibers is likely to perform well enough, but the big variable is always placement. You also have to remember that handgun rounds are poor choices for SD compared to a good rifle, and that the pistol is carried simply because it is more convenient than a long gun. Get a good knowledge of human anatomy in terms of where you need to hit an assailant, and be prepared to shoot until you perceive them losing the ability continue the assault. It might be 1 shot, but could easily be ... 5, or 8.