There is no magic bullet. In .40 and .45 ACP, I am OK with any major brand's premium JHP loads. In .40, I like any accurate 155- to 180-grain load, and have used Federal 155, exact model designation not remembered, Remington 165-grain Golden Saber, Bonded and not, and presently use 180-grain Gold Dots. The latter is available locally for a decent price, as those things go, in 50-round boxes aimed at the LE market. The 180-grain shoots best to point-of-aim in my SIG P229 duty/carry pistols. I have thought about running enough Federal Tactical through at least one of my P229s to ensure function, for felony vehicle stops; of course, that is not a scenario of concern for most folks.
I work for a PD that does not provide us with duty ammo, an anomaly for such a large agency. Most popular seems to be Gold Dots and Winchester Ranger.