Sisters of Battle have about the same gear as Space Marines, but none of the physiological enhancement that makes the latter more than human. What they lack in extra organs and other body modifications, they more than make up with faith and determination alone.
Due to consisting mostly of ordinary human men and women in a galaxy where humanity is severely outclassed by almost everyone else, the Imperial Guard have a well-earned reputation for being Puny Earthlings and the Butt Monkeys of the setting, but they can be this. With little more than a laser gun and flak armour they are forced to do battle with the enemies of the Imperium with nothing but their vast numbers and a variety of tanks to press the advantage. And sometimes, that's enough. While less successful or badly-run regiments are reduced to Red Shirt Army status, the more successful ones are famed for their Heroic Willpower and impressive accomplishments.
The Tanith First and Only a.k.a the Gaunt's Ghosts. As Light Infantry they're even squishier than other Guard regiments, yet that doesn't stop them from pulling off feats that would get other Imperial Guard units annihilated. Most of these feats consist of winning against vastly superior numbers of Chaos forces. Individual characters and squads have been known to kill all sorts of things that could easily wipe away enemies and units that could potentially destroy entire armies of Imperial Guardsmen all by themselves. These include, but are not limited to: numerous Chaos warlords, a Dark Eldar assassin, high-level psykers, a Chaos Dreadnought, and a squad of Chaos Space Marines.
Scout Sergeant Oan Mkoll is hardcore even by Tanith standards. That Chaos Dreadnought the Ghosts killed? A team effort helped by a lucky slash from a power sword and judicious use of flamers. In Ghostmaker, Mkoll kills a Dreadnought by himself. The rest of the regiment doesn't know about this incident, and they still believe him to be completely invincible and theStealth Expert.
Ciaphas CainHERO OF THE IMPERIUM, who has personally and successfully dueled everything from psykers and Greater Daemons of Slaanesh, an Ork Warboss, Khornate Berserkers, and Tyranid Hive Tyrants, Broodlords, and Genestealers, along with countless mooks and minions of all of the above. He certainly gets a lot of help from Jurgen and his trusty meltagun, but he killed the Warboss and a Berserker in single combat and all he had was a laspistol and chainsword. He's described by Vail to be one of the best marksmen and duelists she's ever known. Coming from an Inquisitor, that's extremely high praise.
Stormtroopers, Kaskrin and Grenadiers. Ordinary humans with slightly better gear than the rest of the regiment. On the battlefield they will do everything they can and beyond to match the Space Marines. And often they will succeed.
In the related video game, La'Kais probably qualifies as well. Sure he's an alien, but he's a Tau, which means he's shorter lived and physically weaker than even the average human. And yet his first day of live fire combat he personally killed several battalions of the Imperial Guard, large numbers of Space Marines and several Dreadnaughts, a good deal of Chaos Marines and several Daemons, and he does it all within the timespan of twenty four hours. Alas, he breaks down after that.
The Horus Heresy novels also contain a fair amount of them. The one that stands out particularly was the mute bodyguard Maggrad, who was by the standards of ANY universe containing Space Marines, an extremely proficient killer. This was further emphasized later when he was able to almost best an extremely experienced Space Marine captain. Dinas Chayne, another bodyguard, was also an incredibly talented soldier who was, even more amazingly, capable of briefly matching a Primarch in term of swordplay.
Maggrad, having fought waves of mutants to a standstill to protect his charge, is actually congratulated personally by Horus. The giant, superhuman, galaxy-bestriding Primarch and Emperor's favourite who he practically worships actually tells Maggrad that he admires him. Cue the closest thing to Squee in Maggrad's life.
Guardsman Hawke. In Storm of Iron, he escapes the initial assault (blowing away a couple of Chaos Space Marines with an assault cannon as he does), hoofs it to an orbital torpedo silo, and takes out half of the Iron Warriors Chaos Space Marines besieging the Citadel. He's also the only Imperial Guardsman to survive the whole war, not counting slaves hauled off to Medrengard (though a few Imperial Fists in a Thunderbird manage to save him, whether or not they were in the campaign or just happened to be investigating is unknown). To put that in perspective, he had been written off by his superiors as a useless, foul-mouthed, insubordinate and ill-disciplined Guardsman barely worthy of the name prior to the attack.
Catachan Guardsmen are a level of badass most other Guardsmen can only dream of. Their homeworld is a Death World that eats other Death Worlds for breakfast, where surviving to the age of ten is considered an accomplishment equivalent to graduating from boot camp, and the ones sent to the Guard are the best of the PDF forces. Possibly somewhat expected, the average Catachan Guardsman is basically Rambo.
Sly Marbo, Gunnery Sergeant "Stonetooth" Harker and Colonel "Iron Hand" Straken exemplify it to a suitable degree. For example, Harker carries a Heavy Bolter as his weapon of choice. He carries it alone, with no superhuman enhancements or power armor and he can run with it (Space Marines can't). He is also known for crushing in an arm lock a Ravener that tried to sneak attack him.
Eldar Guardians. Guardians are strictly a civilian militia used to supplement and support the more well-equipped and professional Aspect Warriors, as well as serve as vehicle and artillery crews. However, even these unassuming weekend warriors are amazing fighters by human standards: tellingly, in Necromunda, they're treated as Elite Mooks.
The spin-off RPG Black Crusade features the most awesome woman outside of the Sisters of Battle: a corrupt Imperial aristocrat who became obsessed with control over others and over herself, and eventually became convinced that she could allow a Keeper of Secrets (one of the most powerful of Slaanesh's daemons) to possess her body and then use sheer willpower to not only overcome the possession but also use the daemon's energy to extend her life... andshe wasright. Over the course of decades, she trapped the Keeper of Secrets in her body and painfully sucked it dry until it was cast back into the Warp. Then she did this with two other demons, to prove this wasn't a fluke. To wit, this is an untrained and completely ordinary human woman who atethree Eldritch Abominations. And she was going to go for a fourth until Slaanesh hirself took notice and made her a Daemon Prince out of respect (and as a Stealth Insult to hir own daemons).
Bretonniadoesn't even get the occasional matchlock musket. It is effectively medieval England or France, dropped into High Fantasy, with some Arthurian legend sprinkled on top for flavour. They still hold their own through faith and valour. Heck, the whole kingdom was founded by an ordinary man uniting the Breton tribes under a single banner and against all odds beating the Orcs, mirroring the real life English king Alfred the Great. The only exception are the Grail Knights, who were this trope before becoming Empowered Badass Normals.
Any high point GURPS Character will be this, if they didn't load up on lots of fancy exotic advantages.
Any high-level martial character in any edition of Dungeons & Dragons. Fighters? Yes. Warlords/Marshals? Yes. Rangers? Yes. Barbarians? Yes. Rogues? Yes. Barbarian/Fighter/Frenzied Berserker? OHSHI—
In 4.0 there is an epic destiny for Rangers and Rogues called Godhunter. So yes, your halfling armed with shurikens and a dagger may in fact one day murder Tiamat.
In 4th edition, there are 14 Epic Destinies, counting the Godhunter, restricted to Martial characters alone (that is, Fighters, Rangers, Rogues and Warlords — Barbarians are Primal in 4e). The Adamantine Soldier is a Fighter or Warlord who has become such a master of heavy armor that they are Nigh Invulnerable; nothing hurts them, nothing can get past them, and they will never be broken in body or spirit. The Beastlord is a beastmaster Ranger who becomes so close to his animal companion that they become a single mind and soul. The Dark Wanderer is a Rogue or Ranger who has wandered so long and so far that they have outrun fate itself. The Eternal Defender is a Fighter who becomes an immovable object in battle, whose courage and duty leads to them taking up arms to protect the world or even The Multiverse for all eternity. The Legendary General is a Warlord who goes on to fight in the greatest battles the planes have ever seen, and if they so desire, may conquer all of reality itself. The Martial Archetype is a multiclassed Martial character who bcomes the ultimate warrior. The Perfect Assassin is a Rogue so skilled at dealing death that even Death itself will not dare to approach them before the Perfect Assassin is ready to die — they may even slay the God of Death and take the throne for themselves. The Undying Warrior is the ultimate Fighter, immortal and unkillable. The Warmaster is a Warlord who becomes so skilled that there is no challenge left in reality — defeating armies of demons or outwitting the gods themselves becomes trite, forcing them to seek the Eternal War, the mythical arena where all of the greatest military leaders who have ever lived spend eternity testing their skills against each other. The Dragonheart is a Martial character who reveres dragons as the ultimate embodiment of martial virtue, devoting themselves to those concepts with such fervors that they transcend their original nature and become dragons in body and soul. The Invincible Vanguard is a Martial character is a warrior who yearns to face the greatest threats ever, and who goes on to defeat them all. The Legendary Sovereign is a Fighter, Ranger or Warlord who goes on to found a kingdom, or perhaps an empire, that will never be forgotten. And the Star-Favored Champion is destined to become, simply, one of the greatest heroes ever known.
For Fighters in 5E, the Champion and Battle Master martial archetypes are this explicitly. While the Eldritch Knight combines evocation and abjuration magic with fighting prowess, the Champion is all about training their body to excellence, while the Battle Master is more Weak, but Skilled, applying academics and ancient techniques to the martial arts.
In The Witcher: Game of Imagination playing as a human tends to give this feeling. The game is set in a world with powerful magicians utilising Functional Magic, mutated monster hunters, a few different non-human races with physical capabilities beyond those of humans, personified Gaia's Vengeance and tons of monsters who can eat you whole for dinner. Yet you can and often must stand your ground against all of those as an average Joe with some training. Fluff-wise, humans managed to literally beat the other races into submission while having none of their perks and feats.
In d20 Modern Urban Arcana, a high level hero without special powers can be this. Despite possessing no surnatural abilities, a Fast Hero 5 Gunslinger 10 Sniper 5 is a force to be reckoned with, able to bring down demons with nothing more than oneBarrett M82 shot from more than half a kilometer away, dodge grenades (Evasion) and bullets like there was no tomorrow (Huge class Defense and Dexterity), even if he/she didn't see the shooter, because he/she just had a gut feeling (Uncanny dodge), cannot be flanked (Improved Uncanny Dodge), can use stealth to get the jump on almost anything, spend time to aim an enemy and ignore cover less than one half (Improved Dead Aim), lay down a barrage of fire (lightning shot), is almost invincible when taking cover (Defensive Position)...
The Sourcebook "Mirrors" introduces the Extraordinary Mortals template, which gives characters access to "Skill Tricks", specialized abilities within their mundane Skills. The best of these verge on Charles Atlas Superpower.
Any of the non-super OCC from Rifts, but in particular the Rogue Scholar. For people whose sole class ability is "Knowledge is Power", they sure do have quite a reputation with the Coalition. And by reputation I mean "KILL HIM NOW! Now, HE'S the biggest threat!"
The most famous Rogue Scholar of them all, Erin Tarn, is in her late 60s, and Coalition Enemy Number One. And she's stared down the Four Horsemen of the Apocalypse, on top of many other impressive feats.
Iron Heroes thrives on this, with 9 out of 10 classes having no magical talent at all.
This is the whole purpose of the Guild in Exalted. In a World... ruled by beings so powerful that their original job description was beating up the gods themselves, the Guild's purpose is to provide Puny Humans with a power base of their own. They are so successful that the Guild, rather than the Realm, is the only true power with influence across the whole of Creation, with the wherewithal to bring entire countries to their knees if displeased.
The Burn Legend ruleset allows normal people with martial arts training to compete, albeit at a disadvantage, against element benders, shapeshifters, and guys with the power of the Thousand Hells surging through their veins. With a few good clash rolls and some decent timing, they can even win.
Corvus Belli's Infinity has this in the form of the Ariadna faction. Lacking the technological advantages of their rivals, the nations of the planet Dawn make due with guerilla tactics, a mean-streak in CQC and an ungodly amount of firepower. Also, this makes them immune to the hackers of Pan O or the Nomads* . The one character this troper can think of who isn't immune requires you to be within CQC range. That character? William Wallace..
In Mistborn Adventure Game, non-powered characters not only have the strongest Attributes and Standings, but get two free bonus Traits.
The Pure Mortal template in Dresden Files is precisely what it says it is: a Puny Earthling in a game where other PC options include shapeshifters, changelings, wizards, and even lesser vampires. However, it has a powerful ace up its sleeve: in return for not taking up any supernatural powers, the character gains two free points of Refresh, which translates directly into Fate Points they can use to buy off compels, tag aspects, make declarations, and generally tilt the odds in their favor.
This is just barely possible in Godbound. If you want, a Heroic Mortal can skip out on such things as Legacy talents, cybernetics, Martial Strifes or magical training and stick to abilities that derive purely from personal ability; they'll still get extra hit points and won't be treated as Mooks by Godbound enemies, allowing them (in theory) to face down lesser Godbound toe-to-toe. This isn't likely in the long run, though. Arcem is a world where even a "common mortal" can be a master-level magician, and a heroic mortal will normally be able to acquire some kind of magical items, teachers or allies.