I have to agree. Humans are always bland jack-of-all trades at best, puny at worst.
I think part of it is lack of biological knowledge. People think the only advantage humans have, are our brains. Juxtapose with another species that has the brains plus something else, like more strength or agility or mystical power or whatever, and humans come up short. But humans have other interesting physical characteristics.
I suspect a reaction against this is why HFY (Humanity Fuck Yeah) sci-fi and fantasy has been trending a while now.
In HFY humans are usually characterized as being pretty physically fit, one way or another. Sometimes humans are straight-out OP and most aliens are either weaker or have some crippling disadvantage.
In some universes, humans are straight out OP and Earth is actually a Deathworld that is one of the most dangerous there are. Humans are actually physically very strong.
One common characterization is Humans being persistence predators - humans aren't stronger, humans are enduring, long-lasting, seemingly untiring.
Sometimes a physically stronger alien shows up, but they are sometimes ambush predators - they're stronger, tougher, but they're designed for fast bursts of strength and toughness, they can't maintain that peak for long, while humans are weaker but can out-last them. This is often a thing with speed too - think Sprinter vs Marathoner.
Two HFY example on top of my head:
Nature of Predators: Humans have binocular eyes which are better for concentration, high endurance and are highly empathic pack persistance predators in a galaxy where the rule is herbivory.
Between Worlds/Sexy Space Babes: Humans are different because they're the only known sentient species with a 50/50 gender divide, everyone is more like 7 or 8:1 female-to-male, making humans into the eponymous Sexy Space Babes (to them). Furthermore, our sexes are "flipped" - as in, their females are more like human men in strength and way of thought, while their males are more like our females (their females still look feminine, through to them "feminine" would be more like what we call tomboyish and "masculine" to them is more like we would call bishonen, dandy-esque). Also, humans have faster reflexes and take longer to tire out. We're outmuscled by many other races, but to them, we're fast AND untiring.