Gazoinks: Promising! I haven't played any yet (waiting 'till I finish the main campaign), but there's already a couple of modules and a bunch of modder resources. Check the link I posted above to see some of the things people are working out how to do with the toolset as well.
And I do have to say that I think the built-in campaign is being unfairly maligned. Basically look at StingingVelvet's opinion because he's right. It's not Baldur's Gate. It's a mission-based team strategy game with roleplaying and good writing.
I've started putting down my own ideas for short modules as well, so I can jump right into the editor when I finish the campaign.
DaCostaBR: I'm afraid I might be almost at the end of the campaign already. Is there anything noteworthy in the modding scene available? That remake of the SNES Shadowrun seems to be in alpha, do you think it's worth playing it now? I don't really know what to expect from it since I never played that one.
I've been curious about what people might include in the game aside from what's already available, like if it's possible for people to create their own in game objects or character portraits, assuming they have the artistic skill.
I hear A Lost Lamb is good, but short. According to StingingVelvet Life On A Limb is a bit meh, but might be worth playing to see an attempt at a more open-world style. Don't know about SNES, but I subscribed to it so I'll let you know. There's a few others I don't know much about but also subscribed to. Everything so far is of course pretty short.
You can definitely add objects, as there's a handful already in the Workshop. I'm pretty sure you can add portraits as well. You can't currently add new items and item appearances (but you can change the stats and such), but apparently that'll be updated in by HBS along with some other editor-focused stuff.
EDIT: Hmmm. Anyone know if it's possible to import variables along with characters between missions? 'cause with my mission ideas I was thinking of doing a series, and it'd be awesome to allow some of your choices to carry through multiple modules. I suppose at the very least you could have a questionnaire at the beginning of every mission, but that's kind of an awkward solution.