The most awesome moment (or, well, a series) I had in Adventure mode was with an axedwarf. A freshly minted adventurer, he set out to explore the world, training on overconfident cougars, lions and jaguars along the way. Then I wandered into a desert.
Cue an almost instantaneous ambush by a giant desert scorpion. It was my first encounter with one, and from what I'd heard from my adventurer was doomed. The scorpion smacked him with one pincer and grabbed him by his leg with another. The axedwarf then proceeded to methodically chop off its legs and smash it until it stopped moving, only suffering a yellow wound on the leg and another one on his left arm. He chopped the corpse up and continued his journey.
This wasn't over, though. After some time - still in the same desert - he gets ambushed by TWO giand desert scorpions. Even considering the outcome of the previous encounter I thought he was doomed again. My dwarf didn't think so. He proceeded to block every single attack by both of them with his shield (and if he didn't block something, his armour did) and repeat the dismembering procedure on both of them. One ended up with a crushed stinger and both pincers missing along with three of its legs. The other one had only one pincer chopped off, a very damaged thorax and didn't have rear limbs anymore.
And I repeat, in this fight he was completely unharmed. Against two giant desert scorpions.
But this wasn't over even then. After two or three tiles he got ambushed by yet another foolhardy giant desert scorpion. The fight ended in TWO STRIKES. With the first one, the axedwarf cracked the scorpion's thorax. With the second one, he utterly destroyed its brain. And then it was truly over, and I (and probably him too) felt absolutely awesome.
Nothing else bothered him on his way out of the desert.
Edited for typos.