The Neverwinter Nights (NWN) Aurora Toolset and options to modify the game via "haks" was (and still is to some) the ultimate in creating adventures. Allowing the community to create models or fix tilesets (the community repaired many bugs in NWN for the devs) resulted in something amazing - a prime example was the community creating rideable horses and mounts which did not exist in the game. Yes, I know this could create bugs, as it did, but the community also fixed those as well. There were community organizations (CEP, CTP, DLA) dedicated to pre-check, repair, and approve any model/tileset before posting them for community use. (Isn't this what Tribble is for?)
The toolset itself was accessible to beginners who just dropped items to create their module, or advanced users who could script specific actions and create cutscenes (using a C++ like programming language).
In the end NWN continued as a viable game way past its prime (and my guild still intends to return there some day - after the STO buzz wears off).
As for the Foundry, I was hoping for something similar... however, I will continue to work on my ST stories nonetheless. I strongly suggest that the Devs explore NWN I's Aurora toolset as a guide for improving the Foundry for both STO, and eventually CO & NWN (especially if they wish to have the same success with NWN!!!).