That group was a verification group fired from a Colt 6450 with a Noveske barrel. The OP asked, “how far do you do go for pistol ammo? Just how accurate can you get?” That group is a demonstration of “just how accurate you can get” with 9mm parabellum “pistol ammo.”
If your pistol can’t produce a group like that with that pistol ammo, that means that the pistol is the weak link, not the pistol ammo. As an example, the 10-shot group pictured below was fired from an H&K VP9 at 25 yards using the same pistol ammo as pictured previously. The group has an extreme spread of 1.6”
For another example, the next 10-shot group pictured is a verification group using Federal 9mm Parabellum 124 grain HST fired from the Colt 6450 with the Noveske barrel at 25 yards. The group has an extreme spread of 0.97”
The next 10-shot group fired from 25 yards shows the 124 grain HST fired from an S&W M&P9 with an Apex barrel. This group has an extreme spread of 1.08”
Strictly for kicks and giggles, the statistically insignificant 5-shot group pictured below was fired at a distance of 50 yards using the 124 grain HST fired from the M&P9. The group has an extreme spread of 0.93”
….