Basically cause long story short, I invested a huge amount of time into a mod I "finished" about two years ago, and after a lot of trial and error almost everything was working fine. My life got very busy right around this time, and as a result I also lost a lot of modding knowledge about the specific project I was working on because of just how long certain personal matters distracted me from modding. Now after having more spare time, and re-reading some advice from the past and lots of trial and error I finally figured out the key to fixing that mod, and now it's just a matter of time. That mod in question is my Morrowind vampires mod, and the main issue is making the feeding work properly. (No it's not fixed just yet, but I intend to have it fixed up within about a week if not by today).
So how did I make this mod breaking mistake? Well I didn't realize you could rename a fragment script. And it was just confusion about fragments that delayed the improvement of my mod so much. So when I uploaded the most updated version, I had FORGOTTEN to upload the FRAGMENT SCRIPTS along with the other scripts, and couldn't even FIND the fragment script at that point after some data loss afterwards. If I had only clicked on "Advanced" next to Papyrus fragment, then clicked "Rename Script" and renamed it to something I surely wouldn't miss when uploading said mod would've made it past a broken state long ago. My other biggest modding mistake was that time in an unrelated hypothetical future mod when in vain attempting to make a huge Earth-Sized mod, I tried to have 50 cells open at once to produce a massive world... Needless to say, it ruined one of my hard drives, and I never ever did that ever again. On a much less frustrating note- but still frustrating note, I also learned interiors could be made too large, and that by fusing statics together you could make Skyrim more stable inside of huge places with tons of objects. When it caused a baffling glitch of the screen turning darker.
I feel very excited and relieved now, that I'm probably going to be able to fix that mistake from so long ago... Although the main reason I made this post, was out of curiosity to see what similar severe accidents others had with the Creation Kit. In short if anyone else ever has to use a fragment script, I heavily recommend renaming it. Uploading the regular PEX and PSC scripts generally seems to be common sense... Though it can be all too easy to accidentally leave out a fragment script when uploading if you don't know you can rename it.
The point of this post isn't asking for advice on a specific mod, just rather, hoping that some things some modders learn the hard way other modders can avoid entirely. I hope someone, somewhere, doesn't repeat my mistake of forgetting to keep track of a fragment script when uploading, or trying to load too much stuff in the CK at once, for example. And now I'm very curious what lessons other modders had to learn the hard way. So if you have any stories of massive modding mistakes you've made with the Skyrim Creation Kit, I'd be interested in reading about them, especially seeing as how some lessons are unfortunately often only learned when there's negative consequences. That way you get to tell a story about mistakes you've made yourself, and others can hopefully avoid repeating said mistakes.