The amount of power necessary for the task is finite, unless you plan on using Gauss Pistols for K'kree.
Outside of power, pistols have always had disadvantages simply in terms of their ability to hit the target as well as pure accuracy (which is rarely a real issue at normal pistol ranges). Outside of very tight spaces, long guns have always been better, not just because of their longer site radius, but because of their mass, they don't drift off target as easily.
The site radius issue is vanishing with the modern holographic and red dot sites. "Nobody" is using iron sights anymore.
Having a cartridge designed to punch through strong body armor turns out to have a real problem with over penetration on targets that DON'T have body armor. Over penetration is less so an issue in open field combat, but quite different in close quarters and an urban setting.
So, even if you managed to get a Gauss Pistol cranked up to BMG 50 power, it wouldn't actually be very practical in situations where a pistol might be used.
Other advances for a hi tech pistol could be target isolation and identification with the ballistic computer. Simply point it at a target (i.e. a person), and pull the trigger. Then simply ("simply") hold the trigger down, and let the computer continue to track, and identify the target, and only firing when it has a high certainty of a hit. So, you could point it at someone running down a street, hold down the trigger, and perhaps follow the arrows in the site as you wave the pistol back and forth until it finally decides to fire. You could even do this blindly around a corner. It would also be safer in crowds should the target enter an open area.
Also great for barricaded subjects, or those hiding behind hostages. (Perhaps flick the "really really sure" switch on the pistol to narrow its target potential.)