Stargate SG-1 was the first show I watched to completion and I could barely watch an episode now, it just reeks of a libs idea of what the US military is (or should be) :(
I like the P90 from a "let's do it different to see what's up" sense
FWIW, 5.7x28mm is a very good round for penetrating kevlar vests and is very controllable and has pretty good ballistics out to the ranges you'd practically use a handgun or PDW for
Hopefully you're never in a situation where that would be a useful advantage
It's also expensive as hell per round for its size and a handgun chambered in it is going to have a chunkier grip due to the length of the magwell
Yeah, it's a very engineering round, fine for someone designing a gun assuming they can negotiate a supply chain, but probably impractical for an end user