I have no illusions about this being made 3 years in, but I had a story I wanted to share that could provide more closure to the ending of the main quest of the vanilla game.
Starts off pretty cliched, Courier delivers a letter where a mysterious stranger has discovered the location of a powerful spear (that could kill a God etc. etc... could you retrieve it from this dungeon for a great reward)
When you enter the dungeon you trigger a scripted first-person animation; a spear is thrust through your back and out your chest. You fall to the ground and the screen turns black. With the screen black you hear all the lines spoken by the deadra and nightmother about how they own your soul and then a third-person animation is triggered; companion spirits appear around you and hoist you toward the sky which looks like it did in sovngard. As you near the vortex the screen fades to white.
You wake in a landscape of glowing blue plant life and a swirling orange sky. It's the edge of Aetherius, a purgatory of sorts populated by the Dwemer, where they have lived immortally and peacefully for thousands of years... but not any more because what fun would that be?!
You encounter a shade that looks like the shadow of a small ice-wraith; Alduin. In his corporal form he tampers with the dwemer technology and in the resulting chaos and death, feeds and becomes larger and more complex. There are plenty of Draman variants to go through.
After seeing a couple of large scale Dwemer facilities backfire and learning how the dwemer spent the last few thousand years (time is relative) and taking in a bit of culture, Alduin makes use of a prototype device to return to Nirn (unhindered by his physical form he would grow bigger as he feeds and potentially fulfil the prophecy to devour the world)...
You complete a short mission to recharge the (plot) device (and give Alduin a head start) and follow him to Skyrim, pulling the spear out of your chest as you wake...
Cue the epic battle outside whiterun with drauger and a giant ass Alduin versus the Legion/Stormcloaks and you with the one weapon that could potentially kill him for good