Another really big one in Pokémon is Psyduck. A psychic duck, right? How complicated can it get? Well, while it has psychic attacks, Psyduck isn't actually a Psychic-type.
Psyduck is golden, and it evolves into Golduck... which is blue.
Psyduck is based on a platypus. Ducklett is based on a cygnet. Currently, the only clearly duck-based Pokémon are Farfetch'd and Ducklett.
How I Became a Pokémon Card does not relate to becoming cards in any way. It's a bunch of Slice of Life one-shots, and the name comes from the manga being drawn by people who draw the Pokémon cards and the fact each chapter comes with a Pokémon card.
Archer from Fate/stay night... is not an archer. He has a bow that he can use, but he's primary a swordsman. The same goes for Gilgamesh, the Archer from the previous Holy Grail War. Word of God has stated either could have gotten the title of Saber (in each Holy Grail War, there's the same set of seven titles the servants go by), but the Saber who is King Arthur fits it even better, and since they often used their swords as range weapons "Archer" was the next best fit.
This isn't entirely true since unlike Gilgamesh, who more or less uses his weapons in a More Dakka / Macross Missile Massacre role, Archer'snote EMIYA second most powerful ability after Unlimited Blade Works consists of creating fake Noble Phantasms with his Reinforcement and Projection abilities and then breaking and firing them from a Compound Bow created from an alloy only found in his original time, giving his role as an Archer a very good fit.
For those still wondering about it, The Other Wiki has an article on goldfish and most of them are effectively not golden.
The bit about blue lights is a reference to the Japanese language. The lowest light's color is often called "ao", which is an old Japanese word that refers to any color from blue to green. They now have specific terms for blue ("ao") and green ("midori") and a lot of shades in between, but "ao" still can be a number of colors. In this case, she's complaining about using the word "ao" when "midori" would be more accurate.
The manga series Blame!! doesn't actually involve any finger pointing whatsoever. None. The lead characters rarely even talk. In fact, no one except the creator knows why the series has such an odd, misleading title. It's theorized that the title is a misspelling of "blam!" - which would certainly fit all the gunplay that goes on. Indeed, as the title is pronounced Buramu!, the roman letter title is most probably this mistake. And yes, thegunskickass.
Osaka: Okay, so, you know how we write "dolphins" as "sea pig"? Sakaki: Uh-huh. Osaka: But we use the same character for "pig" in "river pig" and somehow it comes out as "puffer fish", but they live in the sea.
Suddenly the "ocean bacon" (meant to be a random word combo and Noodle's Berserk Button) in the Gorillaz book makes a lot more sense...
The anime adaptation's title is victim to this. "Azumanga Daioh" is a compacted version of "Azuma's manga for Daioh magazine." The anime, being an anime, is of course not a manga. Of course, "Azuanime Daioh" (or for that matter "Azuanime TVTokyo") just doesn't sound as good. Thus, its full title is Azumanga Daioh: The Animation.
This is even lampshaded in one of the episode previews.
Princess Mononoke: She is neither a princess, nor is her name Mononoke. She also isn't the main character or the center of the plot. The Japanese title Mononoke Hime is more obvious about it being an epithet for San, but she is still only one of the four major secondary characters Ashitaka meets during the movie.
The weapon names in Tokyo Mew Mew are usually at least straightforward puns, but the Mew Berry Rod is too small to be a rod and not intended to be used by Mew Berry. And what's the "tone" in Mew Mint's Mintonarrow supposed to mean?
And the StrawBellBell (or whatever) didn't even have a bell originally.
Magical Girl Lyrical Nanoha Movie 1st The Comics is not a prequel to the Movie, but an Alternate Continuity.
There's a manga entitled Yandere Kanojo, which you would expect to be about dating a lovesick girl, especially due to its female lead's first appearance carrying a bloody baseball bat. Not so, as the "yan" in the title is for "yankee" - his girlfriend is a deredere juvenile delinquent.
The female lead's mother, on the other hand...
Naruto A rather blatant example: Kabutowari is a hammer and axe linked by a cable. It's referred to as the "bluntsword" and counts as one of the Seven Swords of the Ninja Swordsmen of the Mist.
There is a species of Digimon called "Flymon" even though they're really closer to bees. It fairness, they do, in fact, fly.
The towering sumoesque Big Guy in Berserk is named Pippin. Which is best known for being the name of a Hobbit or a small apple.
The fourth Black Jack OVA is called Anorexia: The Two Dark Doctors. The patient does not have anorexia. She has a parasite that makes her involuntarily vomit whenever she eats.
The Japanese title of the fourth Dragon Ball movie is "Super Saiyajin da Son Gokū" (Super Saiyajin/Saiyan Goku), during which Goku takes a form that was supposed to be a Super Saiyan, but since it was made before the manga reached the point where Goku became one, it's not what most people would recognize as such (there's no change in eye or hair color, and it's a completely Unstoppable Rage instead of Tranquil Fury). The form was later ret conned by a sidebook to be a "false" Super Saiyan form.
Justin Law of Soul Eater has an attack named "Law Abiding Silver Gun", which is not a gun but a guillotine blade . The name makes no sense except as a Shout-Out to B.Ichi, which had a weapon of the same which was a gun.
Haruhi Suzumiya: The "Endless Eight" story arc does, in fact, end. Also, the "eight" refers to the loop taking place in August, not the number of repetitions, which is more like fifteen thousand. (The anime confuses this further by showing eight repetitions, one episode each. We only see the final one in the light novel.)
The Snipers in EL, who don't ever appear to do any actual sniping in the OVAs, and in fact mostly just use pistols while running around and doing ordinary police work. Though it's possible that The Serial Rapists, while more accurate, wouldn't have gone over as well with the public.
"The Midnight Parasites" is an animated re-imagining of the works of Hieronymus Bosch. Only two of the creatures seen are portrayed as parasites (specifically, reproductive parasitoids), and there's no indication it takes place at midnight.
Tuxedo Mask of Sailor Moon technically does not actually wear a tuxedo; he wears white tie and tails, which is more formal. By definition, a tuxedo (or "dinner suit") has a black bow tie and a suit-style jacket rather than a tailcoat. And either way, it's not a mask. ("Tuxedo Mask" is a straight translation of "Tuxedo Kamen", which presumably sounds more natural in Japanese.)note It doesn't, there's just a long history of super-hero types with "blank"-kamen names. For the purposes of this series however, he is wearing a "tuxedo" and a "kamen/mask".
Sailor Pluto of Sailor Moon has an attack called "Dead Scream." While she does represent the planet named after the mythological King of the Dead, she initiates her attack by saying the phrase in a normal to low-volume voice.
Similarly, Sailor Saturn has an attack called "Silent Wall." Her planet is called the planet of silence, but she initiates her attack by screaming the phrase.
School Rumble is described by FUNimation as "The absolute funniest show you'll ever see that's not about anything that rumbles... ever!", although admittedly there is at least a school...
In Gundam AGE, the DOTS/DODS Rifle is an upgraded Beam Rifle which adds... rifling, meaning that "beam rifle" is a non-indicative name.
Total number of "Crazy Shrine Maidens" in Kannagi: Crazy Shrine Maidens: 0. The closest thing is Nagi claiming to be a shrine maiden as her cover story. (We eventually meet a real one in the manga, but she's a minor character and not crazy.)
The Drifting Classroom is about a whole school, and it doesn't drift — it makes one big jump and then stays put.
The only thing in Strawberry Panic! that even vaguely connects with the title is the Strawberry Dorms, and the original Japanese even uses different words. (The dorms are the Ichigo-sha, where ichigo means strawberry, but the title is Gratuitous English.)
Elfen Lied is not about elves who are pathological liars.
Elfen Lied is German for "Elf Song" which is relevant to the story. Also if broken down, Elfen refers to the horns on the Diclonius which resemble sharp ears. Lied can be related to the word lie, meaning deception, which refers to the split personality of Nyu/Lucy.
Pumpkin Scissors is a war drama. The name only has a tangential metaphorical meaning in the story, which is not about jack-o-lanterns.
Puella Magi Madoka Magica. The name makes it pretty clear that it's about a magical girl named Madoka. Madoka does not become a magical girl until the last episode, and even then it's hard to call her a magical girl because she turns into an abstract godlike concept. However, before this happens we do find out that Homura originated from a timeline in which Madoka did become a magical girl earlier on, meaning that Madoka becoming a magical girl did start the plot in a way.
Espada Coyote Starkk of Bleach has a...wolf motif to go with his character. From his Reserucion forms name(Los Lobos meaning "The Wolves") to summoning a huge pack of exploding energy wolves, and having a "Lone Wolf" type of tendency. Nobody ever comments on this.
Zaku Zaku Hour on SD Gundam Force, lasting barely five minutes per episode.
Less apparent in English, but the Japanese term for alchemy in Fullmetal Alchemist literally means "the art of gold transmutation", which is (almost) never done throughout the series, due to it being illegal to prevent economic chaos.
For those not familiar with Yatterman, you see that girl on the left in this image◊? Her name isn't Yatterwoman, nor is it Yattergirl. She's known as Yatterman-2. It could be reasoned that the "man" in this case is short for "human", but it's still somewhat confusing.
This is an issue that dates back to at least Science Ninja Team Gatchaman, another superhero team whose name ends in "man" but includes a woman.