I too have been waiting for the creation kit, meantime have been exploring some alternate characters.
Skyrim nexus has some very good alternate start RP save games.
An Orc with reasonable starting skills and perks (hvy armor, 2 handed,)
A couple of different "thief" starts, one where you join the thieves guild right away.
A couple of very hardcore "poor" starts, one where you are shipwrecked.
And an "Imperial" where you start at lvl 2 fighting a dragon at the whiterun guard tower.
Some of these have the main quest disabled, others don't.
I also recently finally worked though the whole "throat of the world/defeat Alduin" quest.
Was bugged (esbern doesn't talk) trying to hammer out a cease fire so I could capture a dragon at Whiterun)
Finally figured out how to find the stages and worked through it. Pretty nicely done in my opinion overall.
The mods I can't wait to see
A: Single combat with Ulfric, winner becomes High King.
B Dragon as mount for fast travel around Skyrim.
C Declare war against the High Elves ie Thalmor
D Option to remove unwanted quests from Journal on a line by line basis.