My point is that your derision of elements of SR not being 'competence porn' and comparing it against Leverage is flawed at its most basic level.
The 'superhumanly skilled' people in Leverage are serviced by the story considerably much more than they are forced to service the story. When realistically or logically what happens next is that Eliot is really in either the hospital or in the morgue due to a sucking chest wound, or Sophie is in County behind six sets of steel gates, or whatever, the writers get to say 'No, Hardison sees them coming and Eliot disarms them of their guns before they can get off a shot, then there's a fight scene for two minutes before Eliot's knocked them all out and walks away like the cool dude he is.' The only time a character is in the hospital or in jail is when it will make - for a strictly limited time - for a better story. The writers, in short, aren't playing a game with a randomization aspect; they're only telling a story.
Even starting characters in Shadowrun, however - presuming a 6 or two in their particular area - are extremely competent. I don't think you're understanding the difference between 'security guard has a 3 and a laser sight' - the equivalent of a trained soldier - and 'street samurai has a 6, a smartgun link, and Wired-3'. Just because you consider 'superhuman' to be 'superhero' level something-or-other - powers and gadgets and skills that put you well above the normal human - doesn't mean that's what 'superhuman' means. Modern military guys see at night and have laser and red-dot sights, sure, but it's gizmos external to the body. Give them basic clothes and a gun, and the street samurai - all wired up - will shoot them in the dark, because even naked he can see in the dark; this is what implants are about. And when your standard soldier has a R3 Automatics, a starting character who has a 6 is definitely a kick-ass difference. 'Superhuman' simply means 'greater than human'. And sure, that can apply to SpecOps, whether that's the guys in the US, France, Britain, Australia, or Israel, when it comes to combat the are greater than human - because of intensive training to kick ass and do a DNA scan for names.
Even taking your interpretation (more or less) into consideration though - is 'superhuman' the equivalent of The Bride in Kill Bill? Jack Reacher? Ethan Hunt? Then 'superhuman' is definitely within reach. While it may take a hundred, or five hundred, a thousand or two thousand (or four or six) karma to get a character into 'superhuman' levels (call it a 9+ in three or more skills), and though it may be out of the reach of the starting character, even a basic Wired-3 street samurai can kill eight people in three seconds with a pistol. Without breaking a sweat. A seriously competent adept with a top-notch blade can kill even more, if they're within his 'area of mobility'. I'd call that superhuman. Yes, a nameless punk can drop you if he's got surprise and a big gun, a ton of luck, and you're sleeping; it's a lot less likely if it's a face-off, even with a starting character. It doesn't make you not-superhuman just because you can be killed.
As for the modern tech, sure it helps a lot. It's still nothing compared to a smartgun link, which will cock your gun, indicate to you precisely where you're pointing it (so long as it's in your visual area), allow you to fire your weapon with a mental impulse, and eject the clip the microsecond it's empty, while giving you continual updates on the condition of the weapon and the number of rounds left in the clip + chamber. The only thing it won't do is load and clean the weapon. Ain't nothin' modern that'll do that yet, that's for sure.
And magerun? Sure, mages are powerful - for a limited time, because all that power comes at the cost of drain. I cannot tell you how many times the non-magical-at-the-time Hawatari has eliminated an enemy mage - and at several junctures, the mage was a PC - without in her case breaking a sweat. Because of planning, and all the rest. In a stand-up fight, sure, magic is the trump card - but if you're going for stand-up fights in Shadowrun, you deserve all of the ass-kicking you're receiving.
The point, really, is that yeah, SR is a dangerous place, and yeah, you should be exceptionally competent in whatever your area is - but that being competent exclusively in that area is a bad thing, and for all intents and purposes powergaming.