I'm not even sure a restructure is needed.
Though more/better tools for the DMs to utilize is certainly a thing, which is sorely needed.
Having given this quite a bit of thought after the topic popped up again this time, I've arrived at something of a suggestion, which is rooted in a system utilized for another game around the same time NWN2 was launched: The Ahn'Qiraj War Effort from World of Warcraft.
For those not familiar with it, it was a several month-long event in-game, where players could give all sorts of trade-related items to an NPC to further that faction's efforts towards preparing for war against a looming threat. Leathers, skins, hides, ores, ingots, herbs, and cloth could be donated. And it required no oversight, since everything was tracked on the server's database. Eventually the event completed, and access to the new content was granted to the players.
So how about a similar system here?
Idea
A system whereby a DM can place a special "Effort NPC", which can be configured to accept various resources and/or skill rolls, which cumulatively work towards a shared goal for a group or the entire server. It is persisted through server resets via the server database, and any DM can access the tracking data at any time by interacting with the Effort NPC.
The Effort NPC can only be interacted with a set number of times per day / reset per character, thus preventing a mass-effort by individuals. Though of course multiple characters can work in unison to drastically lower the time required to hit the target goals.
Is it a perfect system? No. But I think it could be a step in a less hands-on experience for the DMs when needing to track some kind of shared progress project.
Scenario 1: A group of people want to build a guild hall
- Request is made on the forums, or in-game to an online DM
- A DM goes to the desired guild hall location
- Puts down the special Effort NPC
- Configures the Effort NPC to only be interact-able for carries of a Token
- Effort NPC hands out one or more Master Tokens to the DM
- Master Tokens are traded by the DM to the guild members
- Master Token allows the creation of a Helper Token, which allows the bearer to interact with the Effort NPC, but not create more tokens
- Both the Master Tokens and the Helper Tokens are keyed to the one specific Effort NPC
- Configures the Effort NPC to accept specific resources
- Configures the Effort NPC to accept skill rolls from
- Lore: Architecture & Engineering
- Craft: Metalwork
- Craft: Engineering
- Craft: Carving & Sculpting
- Configures the Effort NPC to have target goals for total resources and total cumulative skill rolls
- E.g. 4,000 total resources (5 people each delivering a stack of 10 items each reset would be 80 resets / ~27 days)
- 10,000 cumulative total skill rolls (5 people each rolling an average of 30 each reset would be ~67 resets / ~23 days)
- Uses the "Save" option on the Effort NPC, which
- Stores the Effort NPC, along with its location and all its settings in the server database
- Creates related tracking tables in the server database for the Effort NPC to use
- Allows the Effort NPC to be auto-added to the area in the same location after a server restart, by reading from the server database
*: Would need to implement gathering of these (if not already present)
This way an aspiring guild can get started on their plans for a guild hall, without needing to amass millions of gold up-front. Instead they can gradually contribute to the construction of their guild hall in a meaningful way outside of grinding for gold. They can also involve other characters to help out with the gathering of resources and skill rolls (through the Helper Token). Of course a "throw gold at the thing" is still an option at any point, possibly reduced by in-game effort, which is now tracked entirely in-game.
Scenario 2: Dukes decide a foothold should be established in the Fields of the Dead
- A DM goes to the desired foothold location
- Puts down the special Effort NPC
- Configures the Effort NPC to be interact-able by everyone
- Configures the Effort NPC to accept specific resources
- Configures the Effort NPC to accept specific skill rolls
- Configures the Effort NPC to have target goals for total resources and total cumulative skill rolls
- Uses the "Save" option on the Effort NPC
Now the entire server can work together for some common goal, without a DM ever being present, and without anything needing to be documented on the forums. Any DM can log onto the server, and access the Effort NPC to get a status on how things are progressing; possibly with a "top contributors" section, which the Dukes might use for special recognition and acknowledgements.
Idea expansion
One option can be to allow an Effort NPC to accept actual items, such as armors and weapons. These could then be treated as being smelted down or repurposed for whatever effort is going on. Effectively producing a "sink" for unwanted items, and trading gold gains from selling the items for progress towards a project.
A related option could allow characters to expend some of the tracked armors and weapons to upgrade them via a related profession/craft, thus increasing the total progress, but lowering the progress towards raw resources.
Another option can be to allow gold to be added directly to an Effort NPC, which then becomes a "gold sink".
Idea concerns
Most of the progress may end up being just a series of skill rolls and deposits of resources, without any actual role-play involved. For many things in PnP, however, progress towards a long-term goal is measured through skill rolls as the primary driver, and role-play being supportive. That support typically being in the form of bringing in NPCs to help out (which in this case will get replaced by actual PCs). A potential issue for sure, but not one I'd consider all that bad, given the benefits of such a system.
Coding it will of course take some effort. While I am a software developer myself, I'll readily admit that I have no experience with the NWN2 toolset and scripting, and thus no sense of the scope of work to make something like this happen. All I've heard from those who do work with the NWN2 toolset and scripting, is that it's a hot mess and often requires more crowbar and hammer than gentle nudging. Can it be done? I'm confident it can, but it will require time and effort.