I disagree. Modding is still limited by boundries of these temporary workarounds. If you will look at the top mods on Starfield Nexus, all you will see is stuff that are tools, small QoL life fixes, cosmetic additions, stuff ported from Fallout 4 and little things injected to the game. I'm not saying they are not making difference as they're, but it's relatively small fracture of what's possible for past games - and I'm not referring to total conversions like Enderal or Fallout London
Only after release of CK people will be able to introduce stuff like expanding planets with actual content, reducing numbers of loading screens by reworking locations and game's systems, creating new landscapes and filling curent ones with new places to explore, making space travel more exciting and interesting, creating proper story mods that can add more life to the game, etc. I can guarantee you there are people who are already excited about doing this type of stuff for the game. And bear in mind I say that as someone who disliked Starfield and doesn't have too many good things to say about it