Well, I'm on Windows so I use the EA app. However, everything you said are things that I've already tried multiple times before.
Maybe it has something to do with the fact that not too long ago, I quit backing up to OneDrive so everything was wiped. I had to manually go in to the system and get control over my desktop and files, then to OneDrive web and download what I had there. Still lost quite a bit, including cc. I'm thinking that during this process, when OneDrive backed everything, including all files from C: Users - <my name> . So when I then deleted OneDrive, it took all the files, leaving Sims 4 nowhere to save but the Public folder.
I've tried finding out how to make it save where I want it to, but nothing so far has worked. If it does work, it's only for a second, or until I launch the game again, and it's back to Public. Issue here being that everything else I do on my PC is saved to my user folder, as well as everything I download. It's just too tedious to download, open file explorer, open new tab and find Public, then move them there.
TSR CC Manager can't find anything either since everything is wrong, and manually searching for Public doesn't work either.
I'm just so lost at this point that I'm honestly considering just wiping my whole PC and try again from factory new. Worst case is that I mess up even more and have to stop playing the game all together, which I really wish wasn't an option.