"Drill Arrow: This fits into the category of 'arrows that really don't need to be arrows.' There's precious little call for long-distance carpentry. Most people who need to make a birdhouse or a replica colonial rocking chair or something are pretty content to actually be next to the item they're drilling."
It seems that there is no end to the inventiveness of bowmen, especially in Super Hero comics. If a character uses a bow as their main weapon, you can expect that their quiver will hold, at the very least: explosive arrows, arrows which split into nets for capturing opponents, and knockout gas arrows. Furthermore, they will undoubtedly be masters of trick shots, hitting targets around corners or rebounding from behind.
While some other types of weapons get similar treatment (boomerangs and yoyos especially), the Trick Arrow is a trope in its own right that seems to appear anywhere there are bows and arrows. Doubly so if the characters are honor-bound not to kill, since there's very little bows are normally designed to do except shove sharp projectiles into bodies. Deconstructing the trope suggests that trick arrows are almost inevitable with superheroic archer characters. They are useful and straightforward starting points for superheroic characters for a variety of reasons, not the least of which is that Robin Hood is a cultural icon in the English-speaking world. In addition, references for the poses and equipment are fairly easy to come by, as well as being readily identifiable by readers. And therein lies the problem: We Have Seen ALL Of This Before, at least with respect to plain vanilla archery. Hence, trick arrows to surprise the readers and to break up the tedium of writing/drawing ordinary pointy-arrow-work.
Characters who use boring old flaming arrows don't fall under this, unless the arrows are otherwise complex and/or unlikely. They may be pointless, but at least they're possible. A character who uses trick arrows is almost always capable of successfully pulling off a multishot.
Contrast Archer Archetype: simple and sane. Compare Trick Bullet.
Michelle in Read or Die uses paper arrows which can do pretty much anything (being a Paper Master) - the example that springs to mind was an arrow whose tip split in two, allowing it to wrap around the target (a book) and carry on with it securely held.
In a parody of the trope, Akane Tendo of Ranma ½ fame once loaded a traditional archery arrow (the kind used at schools, but with a piercing tip) with a sack of catnip, several times wider than the length of the arrow, and which was heavy enough to bend the arrow as she aimed it at a fast-moving, unpredictable, Cat-Fist Ranma. Amazingly, she hit her mark straight on (even though Cat-Ranma batted the arrow away with his paw.)
Himiko "Lady Poison" Kudo of Get Backers has trick perfumes, which can do anything from corrode metal to allow fire breath to Mind Control to... she's actually got hundreds of varieties, though she only carries seven at a time.
At one point he adapted Doctor Mid-Nite's blackout bomb into an arrow.
He's been seen to use oxygen-mask arrows; particularly puzzling since they are never seen to be fired (that would be impractical), simply used as ordinary oxygen-masks... with the rest of the arrow sticking out of them. This is in keeping with "arrow themed" gadgets, much in the same way Batman had boomerangs shaped like bats.
Perhaps his most outrageous trick arrow in the Silver Age was one that hovered in midair on a miniature helicopter rotor, and then deployed three mirrors around the shaft, allowing Green Arrow to look at the people hidden in the middle of a crowd.
During the early seventies, in the pages of JLA, he claimed — apparently in all seriousness — to have a nuclear warhead arrow. This was before GA went hippie, of course.
In his appearance along with Speedy in the DCAU, they both have quantum arrows, which seem to act as a really tiny nuke when fired at the same time.
Lampshaded in JLA when the new Green Arrow (previously-unseen son of the original Green Arrow who died but came back later) has his regular pointed arrows destroyed by a supervillain and is forced to make do with his father's ridiculous trick arrows, pilfered from the trophy room.
Net arrows! Boxing glove arrows! How about just one! Pointed! Arrow! Dad!
He used a Kryptonite arrow in The Dark Knight Returns, with only one remaining arm, no less. (He pulled the string back with his teeth).
In Oliver Queen's Silver Age origin story, he manages to make a drill arrow while marooned on an island. It's powered by a wound-up elastic (rubber band), which came from his socks.
In "Green Arrow: Year One" (a "serious" retelling of the above), Ollie is trapped on a deserted island and his only arrows are improvised and decidedly pointy. He just uses them for Only a Flesh Wound shots. Later on he gets an actual bow and arrows. At one point he can't get a non-lethal shot(underside of the bad guy's chin, which would punch straight into their brain), so he removes the head of his arrow. His first non-lethal arrow appears later in the same story: He demonstartes his skill by impaling a golf ball with a pointy arrow, then is forced to fire it again in combat. Hitting someone in the groin with a high-velocity golf-ball-arrow apparently works just fine.
This was lampshaded in a recent comic, with (paraphrased) 'One day I'll need an arrow I've never thought of.' He then shoots an arrow that creates a net that they can drop from a burning building into. 'But that day isn't today.'
Batman: I will never - ever - make fun of your trick arrows again.
Also during the well-known "junkie Speedy" arc in the Seventies, GA has an acetylene torch arrow - which comes in handy when he's thrown from a pier, chained to an anchor. The torch cuts the chain and he swims back up in time for Green Lantern to dispose of the crooks who threw him in the water.
Lampshaded in the DC Showcase: Green Arrow film. Ollie still used special arrows, but they were far more realistic and practical. For instance, his trademark boxing glove arrows were replaced with shafts fitted with rounded rubber arrowheads, which served the same function without looking quite as silly.
Post-Crisis, the Golden Age Green Arrow's spot on the Seven Soldiers of Victory was taken by an obscure hero, the Spider. The Spider mostly used regular arrows, but had one special trick in his arsenal — an arrow with a heavy plate for a head, used to disarm gun-wielding foes.
This article lists no less than 16 of Ollie's trick arrows that make the boxing glove arrow look downright sane.
Hawkeye in the Marvel Universe. Once you discover just how varied his arsenal is, including acid, rocket, putty, explosive, bola, and suction arrows, you realize that most of the time he's in a jam it can be easily solved with one of them, but writers tend to not remember that. Exploding arrows seem to be his favorites, at least of the ones that have gimmicks.
One advantage that Hawkeye has is that he keeps the heads separate from the arrows. Those bandoliers he wears? The capsules along them contain the arrow heads, allowing him to change them in and out at will.
One issue of Matt Fraction's series had Hawkeye (in a new costume without the bandoliers) get into a scrape as he was about to label all of his trick arrows. Consequentially, he had no idea which was which until he either took a good look at the head or just shot them and saw what they did.
In Ultimate War, he used a localised mini-nuke arrow on Colossus. Pity that it didn't work.
Hawkeye's mentor Trick Shot used trick arrows as well, such as a sleeping-gas arrow he used to knock out some clowns so that his Mookscould steal their costumes.
The second Trickshot (Hawkeye's brother Barney) uses trick arrows as well.
During the period he impersonated Hawkeye as a member of the Dark Avengers, Bullseye used them as well.
Various minor Marvel Comics villains have their own special gimmick weapons that have varying special effects. The Ringer uses large, hula hoop-sized rings, Boomerang throws special gimmick boomerangs (like the "razorang" and "gasarang"), and Oddball throws specially made juggling balls. Oddball's brother and Death Throws teammate Tenpin uses gimmicked bowling pins, as well; the other Death Throws just used relatively normal stuff (Ringleader stuck with razor sharp rings, Knicknack used various heavy objects, and Bombshell simply had bombs).
Aside from Captain Boomerang, DC has comparatively few villainous users of trick weaponry; you have to dig fairly deep to find the next most notable one, an obscure Green Lantern villain called Javelin who used gimmicked javelins. And there was that one time Signalman became the Blue Bowman, as well.
Several trick arrows are shown in Treefoot's workshop in Thorgal. They are pretty down to earth though; harpooned, whistling, stunning (with a ball wrapped in some cloth instead of the point), crescent-shaped and saddleshaped, an inverted crescent on a broadpoint, supposedly for cutting ropes. In the same book Kris de Valnor uses an crescent arrow to cut off a man's hand.
The Street Angel in Astro City used to use gimmicked throwing rings ("halos") before he turned Darker and Edgier, after which he used halos made of high impact ceramics with a steel core. This fact drives one character into virtual catatonia; the only person who calls himself an angel in Astro City hits people in the mouth with his steel-cored halo.
Quarrel is a more straight forward example of the 'archer with trick arrows' archetype in Astro City. In this case, they're launched from a wrist-mounted mechanism similar to a crossbow.
Batman has occasionally been depicted as using trick Batarangs when the situation calls for it. Batman Returns had him use a programmable Batarang to knock out a large group of Mooks, while a Choose Your Own Adventure-style book featuring the Caped Crusader had him using a "Flash-Batarang" (which emitted a bright flash of light when it was thrown, blinding the Joker in the process) and a "Sprinkler-Batarang" (which sprayed fire retardant to extinguish a fire started by the Riddler) in different storylines.
Shaft from Rob Liefeld's Youngblood plays with the trope. His arrows are the standard pointy variety, but he has a trick bow that doesn't require a string. (According to the tech manual, it uses focused artificial gravity to fire the arrows.) During Alan Moore's run on Youngblood, Golden Age hero Waxman tried to get Shaft to consider using trick arrows, giving examples of older archer heroes who used them. Not one of which had survived the experience.
Alan Moore's run on Supreme introduced the Fisherman and Skipper, Captain Ersatz versions of the Green Arrow and Speedy who used trick fishing lures.
Blackhawk fought a one-shot villain called the Shaft whose gimmick was trick arrows.
Celestial Archer of the Great Ten doesn't technically use trick arrows, but because his bow is a peerless magical weapon created by the gods, he can basically do anything with his arrows anyway — for instance, he can create a bridge or walkway by shooting an arrow that leaves solid terrain behind it as it flies.
Went all out with trick arrows in issue 5, which has him taking down Crux with an electric arrow, and making a fire with a fire arrow. And when he destroyed most of his arrows to stop Crux, we get brief glimpses at a bunch of other trick arrows that haven't been used yet.
Deadpool once made trick arrows during a team up with Hawkeye, riffing on Green Arrow's boxing glove arrow by using Hulk Hands (one even went "Hulk smash!" on impact). However the real trick was that these arrows were all explosive.
The Blue Avenger is a story based on thisChampions character, who is a Captain Ersatz of the Green Arrow. In addition to regular arrows, knockout arrows (with a boxing glove that makes a sound like a fight bell when it hits), net arrows, blinding flash arrows, smoke grenade arrows, grenade grenade arrows, flight arrows, tunnelling arrows, and healing arrows, he has a once-in-a-blue-moon Death Arrow, which does enough damage to kill a Tyrannosaurus rex.
In The Eternal Tale by Manhattan Theory, Anaya uses arrows with explosive enchantments casted on them.
Conan the Barbarian: Thulsa Doom has snake arrows. He uses one to kill Valeria as Conan's party are making their getaway with the Princess, and he tries to use one on the Princess as well, only to be stopped by Subotai, who stops the arrow with his shield.
In Army of Darkness, as part of a last stand against the Deadites, Ash teaches the wise men in the middle ages how to make gunpowder, which leads to them creating exploding arrows. Not only that, but they don't explode on impact - bowmen have to light the fuse, wait about twenty seconds for the fuse to burn down, and then fire.
Also parodied in Hot Shots! Part Deux with the chicken arrow. That's a live chicken - or, at least, it was when it was fired.
As with his comic counterpart, Hawkeye of The Avengers use these to devastating effect. Mostly he sticks with normal broadheads and explosive arrows, but he also has some that hack computers, melt steel, or act as a grappling hook. He has a special quiver that attaches the desired heads to the arrows selected via pressing buttons on his bow.
Guardians of the Galaxy has Yondu, who controls a single arrow by whistling to make it fly around. He shows it's the only weapon he needs when he uses it to take out an entire squad of Kree goons and one ship in the climax.
In Garth Nix's Superior Saturday, there is a sentient RAT with a bow that shot arrows with a glass tip containing Nothing.When I say Nothing, basically nothingness that acts like acid,eating away until the target ceases to exist. Ouch.
In The Dragon on the Border, Daffydd creates an armor-piercing arrow, designed to pierce armor, go through an empty space, and then pierce an additional layer of armor, as opposed to piercing armor and wounding the person wearing it like a normal arrow. Because the enemy of this book, the Hollow Men, are effectively animated suits of armor with no body inside, this enables him to kill three opponents in a single shot, with the arrow going through the first target to hit the target behind him. The arrows are never used in later books, as the design isn't very good at wounding flesh and blood enemies.
In Codex Alera, Bernard is seen using arrows coated with rock salt (which hurts wind furies) against some wild wind furies and later shoots High Lord Kalarus out of the sky with one. In the last book, he upgrades to exploding arrows.
In Mockingjay, Katniss gets some exploding arrows.
Live Action TV
Unsurprisingly we see Oliver Queen using a few of these in Arrow.
But only rarely in combat; he prefers killing (now wounding) his enemies the old-fashioned way. They get more use when he needs to set up ziplines, or bugs.
The Adam WestBatman series had Art Carney as "The Archer," (with henchfolks Maid Marilyn and Crier Tuck), who had (among other things) arrows with a 90° bend in them that went around corners.
Hercules used the blood of the hydra to make poison arrows. Eventually his own death indirectly resulted from this, suggesting that, morally, the use of such weapons was frowned on in the ancient world.
Not to mention the fact that "Ranger", one of the lead characters of the animated series, has a magic bow that seems to be only slightly less versatile than a certain piece of jewelry.
D&D's third edition also saw the Arcane Archer prestige class, with the ability to put spell effects into arrows and create a few other trick arrows on the spot once per day each.
The 4th edition Ranger is an archery fanatic, surpassing previous incarnations. While not using trick arrows per se, the nature of the powers certainly has much the same effect. Notable effects include arrows splitting into two shots mid-flight, knocking enemies back several squares, or outright stunning or dazing opponents. Of course, pretty much every other class can also knock back, stun, or daze opponents, without using arrows.
The later added Seeker embodies this trope even more – a member of that class can shoot things such vines or fairies.
The 1E Oriental Adventures supplement had several non-damaging arrows, including the "frog crotch" (cuts rope) and "humming bulb" (whistles loudly in flight); all of these are based on history, believe it or not.
Unlike the healing arrow. Which was invented to heal front rank fighters. Most of the time it'd heal more damage than it did.
Exalted's Siderials have two charms to do this. The first allows them to fire anything shorter then their arm as an arrow, the second transforms arrows in flight into such things as glass, boulders, enough grain to feed a person, snow, or raw life force.
Solars similarly have an Archery Charm that allows them to infuse their arrows with purified Solar Essence, leading to a number of effects ranging from a burning mandala of Essence that detonates on collision to hot steaming death for the undead.
Some editions of Warhammer Fantasy takes a page from Conan's book and gives the Tomb Kings snake arrows.
Rifts has magic and/or high-tech explosive arrows in just about every setting, for those who cannot or will not use laser rifles like everyone else.
GURPS 4th edition Imbluements system, when applied to archery, allows an archer to do pretty much anything with arrows, be it disintegrating swords, paralyzing enemies, or shooting a cone of destruction.
In Low-Tech including humming bulb, flight (super long range), cutting and "fire cage".
Multiple characters in the Champions universe, including Crossbow (a hero) and Rainbow Archer (a villain).
This sort of character is generally easy to build in systems with "effect-based" power creation rules like Champions or Mutants and Masterminds. Take an attack power with multiple alternate modes (which generally come at a significant discount for only being usable one at a time), give it the special effect "bow and trick arrows", add the necessary drawbacks if it's actual equipment that can be taken away, and you're basically done.
The Archer class in World Of Synnibarr is quite naturally all about this, though most of its "tricks" are actually magical — pardon, based on "Earthpower" — rather than the more mundane type.
Garrett in the Thief series has a wide arsenal of magic arrows to use, most notably the water arrow used for dousing torches at long range. The first game is unwinnable without them.
The "Trick Arrow" powerset in City of Heroes includes, among others, Glue Arrow, Poison Gas Arrow, Oil Slick Arrow, and Electromagnetic Pulse Arrow.
Similarly, Blasters get access to the Archery power set, which allows for flaming arrows and stunning quarrels.
Did we mention the Oil made by the Oil Slick Arrow can catch on fire?
And then there's canon character Manticore: millionaire playboy, Badass Normal, and perpetual snarker. Oh, yes, he uses Trick Arrows as well. Teleporting trick arrows, achieved through hacking into the city's Emergency Teleportation Network.
Champions Online has the Archery powerset which combines trick arrows (Sonic Arrow, Taser Arrow, Explosive Arrow) with trick shooting (Multiple arrows shot at once, Storm of Arrows, and Focused Shot can be upgraded to go through several targets in one shot).
Ninja Gaiden's Xbox remake had armour-piercing arrows. Oh, and the "standard" explosive varieties too.
It should be pointed out that the armour-piercing arrows were not technically "arrows" as such. Rather, they were the cores of Armour-Piercing Fin-Stabalized Discarding Sabot rounds for tank cannons.
Fable had a spell which split one arrow into three; they then Roboteched their way to the target.
The MediEvil games featured a fairly normal longbow weapon (which came in flaming and "magic" varieties), plus a crossbow whose bolts would ricochet off walls at any angle until they reached their maximum flight time and disappeared. Medievil 2 even had a flame crossbow which was basically the same, but it fired flaming bolts. Funnily enough, you get the crossbow before the longbow.
Redneck Rampage had dynamite arrows, and a... peculiar... variant in which the arrow was stuck up the bottom of a chicken. Upon launching it, the whole thing would fly to the target and explode with a loud shriek and a puff of feathers.
The chicken-butt arrow amounted to a guided rocket. The chicken would home in on the nearest enemy.
The Amazon of Diablo II has an entire skill-tab dedicated to these, including arrows that explode, arrows that freeze everything, arrows that split into multiple smaller arrows, and of course the Guided Arrow.
BioShock's crossbow, which, along with firing steel bolts, could fire both incendiary bolts, and bolts which themselves fired deadly electric tripwires.
Unreal Tournament's sanctioned mod Chaos UT introduced a crossbow which could fire exploding arrows or poisoned arrows in addition to the regular pointy kind.
The Chaos Unreal 2: Evolution mod for Unreal Tournament 2004 upgraded both the bolt selection, to include flaming arrows, and the crossbow itself, allowing it to be "charged up" to make regular pointy bolts more useful (they could head-shot unlike the other kinds and when charged would fly further and faster, dealing proportionately more damage as well). It could also fire up to five bolts simultaneously, another staple of trick-shooters.
another Unreal Tournament Game Mod had a bow that had even more arrow options from normal flaming poison exploding (both small frag grenade and Nuke 'em levels of explodyness ) And finally Black Hole and Disintegration Arrows
In Fate/stay night, one of Servant Archer's favourite tricks is to make sword arrows: He can create a sword and transform it into a slimmer, aerodynamic shape, which he then fires from his long bow as an arrow. This has various effects, depending on the nature of the sword, and can cause them to explode on contact by overloading them with mana. In the original Visual Novel he uses a sword that can twists space around it as it flies, allowing it to pierce any target; in Fate/hollow ataraxia he uses a sword that moves at ten times the speed of sound and will change course to hit its target, even if it's already missed.
Link in The Legend of Zelda has used silver arrows, fire arrows, ice arrows, bomb arrows, and light arrows.
The Hunter class in World of Warcraft has numerous different "shots" (they can be used with guns as well as bows but otherwise fit the trope). These include several variants of poison shots (scorpid sting, viper sting, wyvern sting etc.), an "arcane shot" that deals magic damage, a shot that dazes the enemy, and the Aimed Shot (which reduces healing on its target). There's also a trap-throwing arrow, which lays any of the hunter's 5 different kinds of traps where it lands, a flare which reveals nearby stealthed opponents, and ExplosiveShot.
Raven from Tales of Vesperia's arrows do everything from laying explosives to healing. His bow can even be used as a double-bladed sword, since it's got sharp edges.
And while we're on the subject of the Tales Series, Woodrow Kelvin from the Tales of Destiny remake has a very interesting move called Bassaiga. He sets up his bow so that it looks like he's going to shoot his enemy, but then he pulls his sword out at the last moment and slashes them. How's that for a Trick Arrow?
Heroes of Might and Magic 4 features several different kinds of arrows that add special effects to ranged attacks, including the Arrow of Stunning (stuns enemies), Arrow of Slaying (does extra damage to the most powerful creatures like dragons), Poison Arrow (poisons enemies), Silk Arrow (restrains fliers) or the Flame Arrow (Area of Effect damage).
Heroes of Might and Magic 5: The Rangers racial ability is largely based around this. Imbue Arrow lets him put any offensive spell on his arrows, who deal more damage by default if they hit one of his chosen favored enemies. For extra fun, he can fire arrows that will hit any enemy stack of favored enemies for full damage each.
The standard ammo for the crossbow in Strife is electric bolts, which are a good choice to destroy robotic enemies, though they are useful all around. Poisoned bolts are a completely silent One-Hit Kill on any organic mook and don't raise any alarms, though using them against anything else is a No Sell.
While not arrows per se, Mass Effect 2 features different kinds of bullets. There are armor-piercing, explosive, incendiary, and freezing bullets to name some examples.
The oddest of the bunch is Jack's Warp Ammo, which essentially consists of bullets empowered by her brain (or yours, if you choose it as your bonus power) to do more damage to pretty much everything.
To be fair, mass effect fields are easily incorporated in a lot of technology without the need of a biotic generating them. They probably stuck an eezo core inside the bullet. Although, considering the usual bullets in the Mass Effect universe are just tiny (sandgrain-sized) pieces of metal that are produced at need by being shavings from a metal block inside the gun, it'd be hard to put anything IN them, so direct empowerment by the shooter is more likely.
Skyrim also features Trick Crossbow Bolts, added in the Dawnguard DLC; by mixing up some crossbow bolts with elemental salts dropped from Atronachs, you can get exploding fire, frost or shock bolts.
Dawnguard's main quest centers around Auriel's Bow, a weapon supposedly used by the god Auri-El, which by itself burns the targets of its arrows with sunlight, dealing triple damage to undead. However, it becomes powerful enough to affect the Sun itself when combined with one of two trick arrows; Bloodcursed Arrows, made by dipping regular Elven Arrows in the blood of a Daughter of Coldharbour, blot out the Sun for one day and lets the various monsters of the night (including you, if you became a Vampire Lord) move and attack freely. On the other hand, Sunhallowed Elven Arrows, blessed by the last priest of the Snow Elves, rains down beams of divine light from the Sun and damages every enemy in the vicinity, again dealing even greater damage to the undead.
Oddworld: Stranger's Wrath has the main character use a crossbow that fires critters that have various different effects, such as baiting the enemies towards them via Trash Talk, a skunk that serves as a stink bomb, bats that serve as explosives and others.
Fallout 3 has the Dart Gun, which is essentially a crossbow that fires pre-war throwing darts... dipped in radscorpion venom. While it does extremely little real damage, the poison immediately cripples the target's legs, drastically reducing its mobility. Extremely effective against Deathclaws, which are rendered pretty much helpless. Deathclaws are one of the deadliest creatures in the entire game otherwise.
In Planescape: Torment, Nordom's crossbows usually shoot regular, pointy bolts, but you can find and/or buy all sorts of variations (and even tell the crossbows to make some specific types themselves), such as acid-filled sponge bolts, bolts containing insane wind spirits in the tips, cubic bolts incorporating the essence of order, frog-crotch bolts, and the ever-popular "Rule-Of-Three" pyramid bolts that separate into three bolts.
In addition to normal, pointy arrows, Dungeons of Dredmor features a number of increasingly improbable ammunition. In particular: nuclear warhead arrows, and arrows that fire an Eldritch Abomination.
In Guild Wars 2, the thief shortbow skills in particular show off variations of this trope. Some warrior and ranger bow skills also fit.
Some archery skills in Dragon's Dogma seems to come off as this with the character pulling stuff out of their pocket to ready the skill. Such arrows include Drills, Flash bangs, Poisons, and Whistles.
The new Tomb Raider reboot gives Lara several different arrow types to play with, primarily fire arrows for extra damage and rope arrows which serve as grappling hooks, to bridge gaps and pull distant objects. The fire arrows can be upgraded into napalm and explosive arrows, whilst the rope arrows can be upgraded with a rope ascender, letting Lara pull heavy objects.
Dark Messiah of Might and Magic gives you the Rope Bow a short ways into the game. It shoots arrows that, upon striking a wooden surface, deploy a rope you can then climb. It becomes a key gameplay mechanic from that point on, allowing you to get into and out of places that would otherwise be unreachable.
Video Game/Terraria allows you to be quite a good archer, providing you with automatic crossbows and arrows ranging from flaming to firework ones.
The Knifeketeer, a recurring superhero identity of Rick in Basic Instructions, is a parody of superheroes like Green Arrow, and thus uses trick knives. The most commonly observed one? A boxing glove knife, natch.
Appears a couple of times in Sluggy Freelance. In this strip, Alt-Torg has a quiver of talking arrows which includes at least one flaming arrow and one grappling arrow. These are actually somewhat plausible (aside from the talking part). Where things get to silly levels is in a later arc when Riff uses magic arrows that confuse and slow down a monster on impact, until Torg points out that putting a regular arrow through the monster's head might be more effective in taking it down. Justified since this takes place inside a video game, where Rule of Cool reigns supreme.
Darkhood in Interviewing Leather is a Bad Ass Normal, probably based on Green Arrow. So obviously he has a bunch of different arrows like taser arrows, grappling arrows and even *gasp* normal arrows.
In Worm, both crossbow-wielding superheroes, Shadow Stalker and Flechette, have trick arrows: the former has her tranquilizer bolts, the latter has a chain-generator she can use to turn her arbalest into a Grappling-Hook Pistol.
Green Arrow is a recurring character in the Justice League cartoon from Unlimited onwards, and naturally gets to show off his collection of trick arrows. Huntress, by contrast, prefers "the pointy kind that go right through you."
GA: (freeing himself from ice) "And Black Canary said a buzzsaw arrow was self-indulgent."
The Angry Archer from Transformers Animated. (He's basically a villainous version of Green Arrow, though he's also a homage to staff member Aaron Archer and a fan of Robin Hood.)
Speedy from Teen Titans, who is a (possibly former) sidekick of Green Arrow. In one episode, unable to use his trick arrows or bow, he uses nearby vehicles and supplies to make a giant bow, firing himself as a trick arrow to defuse Control Freak's threat.
Scarlett from G.I. Joe had a quiver full of Trick Quarrels for her crossbow, and Lady Jaye used Trick Javelins.
In Darkwing Duck, Gosalyn's hero identity was Quiverwing Quack. Among her trick arrows were glue arrows, boxing glove arrows, and at least one pencil sharpener arrow.
In the 1970s FilmationFlash Gordon, the Arborians used ''ice arrows'' as their weapon of choice. Interestingly, there was never any indication that this was anything less than lethal (no Harmless Freezing here), it was simply a way to avoid the ugly messiness of a conventional arrow. Though the ice arrows did turn out to be very handy for putting out fires, especially the larger varient that Vultan and his Hawkman are able to throw down from the air without needing bows.
Green Arrow, Artemis, and Red Arrow all use trick arrows as their primary weapons in Young Justice. In addition, Artemis uses trick bolts for the compact crossbow she carries while in her civilian gear.
In Wakfu, pretty much all of the Cra race has these.
In one episode of Samurai Jack, Jack is pursued by the greatest hunters in the universe, each armed with a different weapon. One of them is an expert archer — among his arsenal are arrows that are actually petrified snakes, which proves Jack's undoing when he performs an Arrow Catch.
Mongols and other Eurasian nomadic people had many specialized arrow heads (and occasionally arrows). Some were designed to whistle (both to communicate with troops and to scare the enemy), some for hunting, some to pierce armor, short range arrows, long range arrows, barbed arrow heads, (allegedly) poisoned ones, even some that aren't even pointed (for stunning people). Iranians had a two pronged arrow for hunting, while Turks had a really small arrow for use with a wooden guide that would essentially turn a regular composite bow into a crossbow. So quite clearly, Truth in Television (just not in the way they show it).
The Japanese developed arrowheads that whistle and cut rope.
A South-American tribe once made arrows for detaching feathers from bird mid-flight, while leaving the bird relatively unharmed.
In ancient Persia, returning arrows were known, and have been reconstructed and used. They're light, and have very short range, and are strictly for showing off the fletcher's and archer's skill, but they do indeed return.
There's a tutorial for making explosive arrows or crossbow bolts in The Anarchist's Cookbook (look it up if you really want to know), albeit both Awesome, but Impractical and highly dangerous.