Cyberpunk 2020 is the game I think of for this. In the 2020 rule book, the bloat wasn't so bad as there were usually 2-3 weapons per category. Like real life, there are factors to consider when choosing a weapon like price, reliability, number of shots, etc., etc. The Dai Lung Streetmaster pistol does more damage than the Federated Arms X-9 and it's $50 cheaper. But the Dai Lung is unreliable and the Federated Arms is reliable. Of course why not just buy the Militech Arms Avenger because it's very reliable and cost the same as the Dai Lung Streetmaster. Yeah, it gets weird.
In real life of course there's no obvious best. Someone might favor the Glock 17 while another person loves their Beretta M9. I know gun bunnies sometimes like to get into the minitua of muzzle speeds, stopping power, how many grains the bullet is, etc., etc., but sometimes it's really about how comfortable the firearm feels in your hand. I had a Taurus 9mm that wasn't particularly comfortable and I could barely hit anything I aimed at whereas my Colt .357 was comfortable and I feel like I can't miss with it. It's not easy to convey preferences into mechanical differences though.
For a game like Cyberpunk, I usually expect the PCs to be better equipped than your average ganger or security guard, so I'm perfectly fine with them selecting whatever the best gun in their category is. When designing NPC threats, I give them weapons that make sense. For gangers and low level security, the weapons are usually on the cheaper side. Gangers don't typically wear armor whereas security will often have light armor of some kind.
Cyberpunk Red categorized weapons by light, medium, and heavy for pistols, light/heavy for submachine guns, etc., etc. but they didn't bother having different models made by multiple companies. You could have a low quality rifle and just say it's a Dai Lung, but it isn't built into the system and I was surprised how much I missed it.