Really, my main concern is will this ruin my dynasty? I just had some interesting things go on but why even add to the story if the game is borked? My heir can repaint all the missing paintings, (she's level 10 painting close to maxing the aspiration), but that takes time from other things she has to do. I can replace the lights and windows but the collectibles would take time.
I get so frustrated with the save files since they are all numbers and no way of knowing which file belongs to which game without doing a process of removing one set, going in game to see what isn't there, etc. I stupidly did not do any backup or save my saves folder anywhere. (sigh)
So, I don't us CC or mods. I DO use MOO a lot and usually remember to take it off when done. It's one of the few cheats allowed in dynasty play and as a builder I really rely on it a lot. I also enlarge items. None of my other Mooed items or enlarged items were missing from anywhere else in my mansion. Just that one room.
I DID notice that in a mansion I just uploaded to the gallery, all of the shrubbery hedge I place around the perimeter of the build, done with MOO, are partly missing. Not all of it, just some. Nothing else in that build was missing even though MOO was used throughout with various items in different rooms.
The other thing I discovered is my family inventory was suddenly full of household furnishings I did not buy, (could have come from the recent marriage I suppose), and I have a complete garden harvest appear without having my Sim do the harvesting. This was on the third or fourth try at "fixing" the issue. Prior to that, around the second try, I had my Sim harvest only Granite Falls plants and all the plants disappeared after! They did not appear in my inventory but this last going back into the game, I got a complete garden harvest WITHOUT having anyone harvest. Haven't checked to see if the plants are still there.
I've posted this to crinrict's help. At this point I'm going to continue to play and see what happens, although I dread what today's download of the new EP will do.