These are what we call the 'YMMV items.' Things that some people find in this work. We call them 'your mileage might vary' because not everyone sees these things in the same way. This starts discussions in the trope lists, a thing we don't want. Please use the discussion page if you'd like to discuss any of these items.
Cliché Storm: Most of the campaigns, being set in a traditional Tolkienesque setting. There are a few exceptions however.
Demonic Spiders: Many of the Level 3 and above units, but the literal Giant Spider takes the cake, having many hit points, a slowing distance attack and a really powerful bite which inflicts poison to boot. The Giant Spider is so strong, it can kill Delfador within two turns if the player is unlucky. Many Prestige Class enemy units can be this as well.
Ear Worm: A huge portion of the game's soundtrack. This can be expected with compositions with a highly emphatic rhythm like The Dangerous Symphony, but even things like the calmer portions of The King Is Dead or Breaking the Chains can worm their way into your head and come back at unexpected moments (when you haven't played the game for days).
Ensemble Darkhorse: The elf lord Kalenz probably qualifies. Initially, he appeared as a supporting (albeit important) character in Heir to the Throne. Later, he became the protagonist of his own campaign, The Legend of Wesmere, which is so far the only mainline campaign to have a multiplayer version. And he also gets a significant role in Delfador's Memoirs. This makes him probably the only character to appear in three (four if you count the multiplayer one individually) mainline campaigns.
Version 1.9.5 of The Tale Of Two Brothers has him mentioned. The player character becomes his pay-for escort during the epilogue. That makes four if this version of the mainline campaign is committed into the release builds.
Grogg the troll is a (theoretically) completely optional party member in Under the Burning Suns. Unlike the other optional party member, he is beloved enough by the fanbase that he even got his own spin-off campaign.
Evil Is Sexy: Asheviere. The add-on Ooze Campaign even has a custom unit with Asheviere's sprite whose description is simply "[Character's name] is a pretty young woman with an unsettling fascination for death", pretty enough for a paladin to fall in love with her despite how evil she is.
Goddamned Bats: Any highly evasive unit has elements of this, but the actual bats(high movement, high evasion, and draining attacks) fall solidly under this trope as fast, obnoxious, and deceptively hard to kill.
Saurian skirmishers/ambushers in any appreciable quantity are certainly this. Saurians are highly evasive in difficult terrain like forests and swamps, fast, ignore zones of control, have ranged and melee attacks that do more than tickle, and are cheap enough to recruit mobs of, at least for their faction. Fighting them, especially in some campaign scenarios where the AI can buy leveled versions of them directly, can be compared to juggling fetuses: slippery, unpleasant, and more likely to get blood everywhere than accomplish anything worthwhile.
Orcish Assassins also come to mind. The combination of high evasion in almost every terrain, multiple low-damage but poisoned ranged strikes in a single volley, and marksmanship on the attack so they can hit even other evasive units quite reliably makes them highly annoying and distracting, and even trying to deal with them via magical or marksman attacks in turn is a pain...because even if they finally do die to one of those they'll probably still have poisoned their vanquisher one last time first.
Idiot Plot: In Heir To The Throne, after Konrad defeats Li'sar the first time, he not only lets her go, he even asks her for directions. Of course, she leads him directly into an undead-polluted area.
Jump Scare: Any unit that can turn invisible in certain circumstances can cause this and massive amounts of groaning as they ruin your strategies. While the most common scenarios are being ambushed by Woses in the forest or Shadows/Nightgaunts at night, or even worse, trying to take over an enemy town only to remember that a Fugitive had just stationed up in it far too late, some scenarios (such as "Crossroads" in Heir to the Throne, "The Drowned Plains" in The Eastern Invasion, and at least one optional quest in the add-on campaign Elvish Dynasty) involve enemies with none of the abilities that grant invisibility being coded to ambush you as well. An army of skeletons could also invade an unsuspecting castle on an island from deep water (where they are invisible, but move very slowly). Thankfully, the AI (and most players) seem to deem the undead tactic too Crazy Awesome and impractical to use.
Running the Asylum: The game is completely built and developed by people who are essentially volunteering non-paid fans. Fans make the art, the music, the campaigns. Fans write the lore and decide the canon. And, so far, they've been doing a pretty good job.
That One Level: 'Evacuation' from Eastern Invasion. You start out surrounded, and have to choose between getting your heroes to safety at the cost of most of your army or fighting three large groups of max-level trolls.
The final scenario of the Dead Waters campaign. Mainly because the three enemy bases never seems to run out of cash while you can barely hire two waves of troops to your aid.
The Scrappy: The heroine of the fan-made, downloadable campaign "Love to Death". She even murders some lizardmen in cold blood only because they were worshiping a Death Goddess (but lacked the power of creating undead.)