@Pick-a-boo_doo Thanks for testing that. Unfortunately I can't access the video. But again I'm so impressed by the way things like this can be presented on PC and how well you've analysed it all.
I made the living room and bathroom platforms the same way and the lot was created around 6 or 7 months ago for my mermaid but at the time I didn't notice anything. It's the new ceiling coverings that alerted me to it and made me think to test it while we were discussing this current issue.
It's funny you mention getting some rest, I honestly dreamed about this last night (not a great sleeper with a back problem). I kept having dreams about Sims ceilings and platforms! I think it's because I've looked at it from so many angles and found it quite confusing I'll admit.
But if I understand you correctly you mentioned a Sim being unable to walk into an unoccupied house? Am I getting that right? Because my Sims can never walk into an unoccupied house, I didn't think it was possible. They can only go into the garden. I get the message that says "Knock on Door" then a bubble that says "No one lives here". But I may be misunderstanding your point apologies if so.
I'm expecting that the build experience on console will be getting fixes at some point as we've been in period of changes and ongoing kind of maintenance since January. We're in constant dialogue about it and all feedback is being taken no matter how small, I wasn't hopeful about it at the start of the year but it has had some improvements since. Some things that were fixed, broke again with the last patch but I know it's being looked at. We have actually asked for more dynamic controls to catch up with PC capabilities. For example we don't have the roofing options that PC has.
Added to that, my game is behaving strangely in live mode as well since adding horses...but they are still so worth it!