While I don't know much about modding, I do know Adventure Mode, and what's wrong with it. And I'm sure if you were to seriously lobby for support, both on this child-board and elsewhere, you'd get the support you need. To make it happen, though, you need to make it clearly known that you're interested in overhauling Masterwork adventurer mode.
At the very least, the start of an Adventurer overhaul is to modify the custom races slightly to make them viable adventurers. Currently, Automatons are nigh invincible and do not gain experience in skills. Warlocks never get hungry, thirsty, or tired. Citizens found in towns are all naked and unarmed (I recall in vanilla versions of DF, peasants wore clothing and wielded knives). I could post a list of small oddities I've found in my playthroughs, but for the sake of length I'll wait.
At least one of those small things should be a decent launching pad for a better understanding of adventure mode and its modding. I suggest, at the very least, you play around in adventurer mode a bit, if only to familiarize yourself with its mechanics, and what you feel it lacks.
