The consequence of betraying your side, in the Season Unending treaty, goes unused, as well as some scripts for A Whispering Door. I'd like to know what tutorials are recommended for the task of adding these into Skyrim. I've completed the official ck tutorials, but they aren't very specific to my needs. Any help or pointers to the right guides would be loved.

So you basically want to add quests? I think Doug Hamil's video tutorials are the best for that, even though I hate video tutorials. The first one is http://www.youtube.com/watch?v=Qfcet5hf5bs, but there are I think four more.

Just be aware that there is http://www.gamesas.com/topic/1381788-the-new-unofficial-creation-kit-bug-list/page__view__findpost__p__20945623 with the current 1.6 game where editing dialogue in vanilla quests can cause the existing dialogue not to appear and the connected quests to break. So if the restoration you're planning involves adding new responses to existing topics, adding new conditions to existing responses, that sort of thing--it'd be better to wait for a bugfix before proceeding beyond the planning stage.

As Ingenue writes, you should be okay if you add new quests. http://www.gamesas.com/topic/1382989-adding-new-dialog-to-existingvanilla-npcs/ may be somewhat relevant.