I would personally love to be able to smith a number of quality weapons and sell them at a village, a village that would at a later point attack the neighboring village using those said weapons. And after enough villages were taken over with those same weapons, I'd start dabbling in Armorsmithing and eventually start producing quality bodyarmor for the rest of the world.
Or maybe there could be random farms scattered between bigger towns, farms that would receive regular attacks from bandits or other wildlife. I would immediately smith some breastplates for those poor folks, so that food supplies from those bigger towns wouldn't run out. OR if I was feeling especially evil, I'd raid the farms myself. And people would start starving. And that would incite chaos as people would rise up to arms and start marching towards the nearest neighboring town (the one that HAS food). (I suppose it's possible the boring thing would happen and they'd just start hunting food themselves).
Hell, I just might smith a bunch of swords and drop them near a bandit camp or something. And later check what kind of chaos they have caused.
Another thing I dream about is starting a career as a chef and make piles of money with my famous meals. Word would get out and people.. well, characters, from all over the world would come to taste my worldfamous -**((Roasted warthog innards))**-. I would then make an effort to spot any particularly rich individuals, write down their names and find out where they live, and I would then proceed to raid their homes or even castles. Cuz more money.
DF Fortress Mode has many many skills that should be made available and usable in Adventurer Mode.