I gave my lot Private Dwelling as soon as I loaded my save and unfortunately it does not keep the notifications or the Sims out.
Too many bugs and annoying "features" like this one, react to disgust, and reputation cheering every few minutes to enjoy the game so I'm just going to opt out of the system.
I do agree many of the features are very annoying, game breaking annoying in fact.
When your Sim gets a celebrity level your best bet may be to lock outside doors to household and employees only if you have them, it only happens generally within a day or 2 of getting a new celebrity star.
