Now, there are three futures that I see:
Good Ending: Great modders have worked tirelessly to make competent gameplay overhauls, new story content (not main story, obviously) and improve base building into something useful and fun. These mods are getting dropped for free at the same time Creation Kit is released or soon after, either on Nexus Mods or as free Creation Club content with the blessing of Todd Howard himself. The community is happy, as at this point getting anything is like being granted water on a desert.
Bad Ending: Great modders have worked tirelessly and after Creation Kit is released you will be able to enjoy their wonderful mods that make Starfield vastly better experience...right after you pay the price for those mods on the Creation Club website. Nothing's free, the community melts down and the money flows. The greed wins. That would be shortsighted and not work in favour of long-term Starfield support, but a corporation wouldn't kneecap a project's long-term earnings by focusing on short-term money benefits, right...?
No-Hope-Left Ending: Modders have done nothing substantial as the mooding tools were half-baked so far. Vastly delayed Creation Kit launches after a year from release with nothing to show for it. The mods are being make from scratch once the tools are released, so it will be another year or two before we see anything worth looking at. The modding community for Starfield never reaches its potential and remains a shadow to Fallout and Skyrim's. The Starfield slowly dies, disappearing from sight of everyone.