GURPS Illuminati University actually has several Department of Redundancy Departments.
Naturally, Alpha Complex in Paranoia actually has a Department of Redundancy Department. And many other variations on the theme. "Oh, this is the Complex Supply Bureau. You want the Bureau of Complex Supply."
Ferrus Manus—whose name means "Iron Hands"—Primarch of the Space Marine chapter the Iron Hands, who actually has iron hands.
The chant of the chaos marines "Blood for the Blood God" and "Skulls for the Skull throne".
Special character Canis Wolfborn is a Space Wolf, a Wolf Guard in Harald Deathwolf's Great Company, Lord of the Wolfkin, was literally Raised by Wolves, wears a wolf tail amulet and a wolftooth pendant, and rides a Fenrisian Thunderwolf into battle. This and similar examples led to a minor meme where random nouns and names are replaced with WOLF WOLF WOLF.
The Chapter-creation rules in Deathwatch allows for the name-generation table to spew out some pretty tautological Chapter names, like the Guardian Guard, War Warriors, Bloody Blood, and... Death Death.
Due to trademark issues, the Imperial Guard were renamed the Astra Militarum...which is faux latin for "Space Army". Their Stormtrooper units became "Militarum Tempestus" (no points for guessing what this is suppose to mean).
In Dark Heresy, there is an ascended psychic power called Malleus Hammerhand, or, in other words, Hammer Hammerhand.
Khârn is arabic for "betrayer". Similar to Malleus above, his name and title translate fully as Betrayer the Betrayer.
In the fantasy world Glorantha (featured in, among other things, the RPG RuneQuest) the local equivalent of China is bordered by the Shan Shan Mountains. In one Chinese language - I have forgotten which - "shan" means mountain. So they are the Mountain-Mountain Mountains. Did we mention that they are really high and impassable?
Due to some confusion when he first introduced himself, Ravenloft's most infamous lich is referred to as "Azalin Rex" in official court documents of his domain of Darkon. Invokes this trope, as "Azalin" is actually a mangling of his old Oerth title of "Wizard-King", thus making him Darkon's "Wizard-King King".
In the RPG Orbital, one space ship has "two emergency low berths for emergency use", and in outposts, "Individuals or teams will be regularly rotated back to the main installation on a regular basis".
The Low Life card game Dementalism is described on the back of the box as, "An ingenious game of ingenious ingeniousness."
Smash Up has a minion called "King Rex." It's a Tyrannosaurus Rex.
The producers of simsense recordings in the world of Shadowrun sometimes have to whip up portions of those recordings from scratch rather than live-record it, usually because sensations associated with spellcasting or astral phenomena can't be captured by sim-tech. Industry jargon refers to such computer-generated patches of experience as pseudosim.
In Delta Green, one antagonistic group are Americans Against Covert Enemies, basically a racist hate group that's secretly backed by a ruthless and very well-connected Mythos cult. The sourcebook they're covered in contains a list of their preferred targets, which mentions Islam five times even before discussing their direction after the September 11 terror attacks.