@simsplayer818 This has now worked. Microsoft support told me to do a full console reset on my Xbox One S, remove everything. Then I set up my console again, applied my settings automatically and had the arduous task of installing everything again, base game plus 33 packs (showed up in my games and apps so didn't have to go via the store) which took 8 hours in a rural area with fluctuating broadband speeds. Luckily I only have the Sims on my console. Every pack installed again with no hiccups. It did a data synch (which wouldn't work before) as I loaded up my game and my game saves were back when they were missing before. This worked for me anyway.
Really helpful Microsoft support, first person hung up on me. He's rung 3 times to check progress and is giving me a call again later to check again. It's taken 12 hours of hassle and I really wish they'd do something about the stability of this game before they bring out shiny new content. I also think I need a more powerful console now it's so big.