99% of my campaign quests tend to result in 'solve 'ems'. I often try to entice thinking with unscripted events prior to making areas with code in them with prethought puzzles for you guys to solve. The reason I script them is because it's all automated that way, and I don't have to worry -too- much about jumping around and emoting things, when it's all done for me, which means I can concentrate more on you guys, and whatever alternatives you happen to come up with.
The issue I have at the minute is i graduate in 3 weeks and have an exam and a deadlien in 1 week, and a launch for our game for work in 1 week and so on and so forth, so you've yet to encounter any puzzles as such. My puzzles tend to be labeled 'zelda puzzles' on the grounds that they are, apparently, like Zelda puzzles. They so far include mechanical means of controlling magically defended paths (3 players necessary), chess, balancing weights to open a door, placing items on correct altars to open a door, and so on.
My 'big bad's' tend to be world threatening as one would expect with a campaign but they're not in your face. They also tend to have scripted AI which makes fights more interesting and vaiable, often teleporting for the weaker player, reflecting powerful spells back at you, throwing grenades, that kind of thing. They have a habit of floating around in the shadows and provoking thought. If that's your thing then gimme a few weeks and i'm sure I'll have something in the forge.
_________________
Never under estimate the power that language imparts. Sticks and stones may break your bones, but words can break hearts.