I don't like having my Sims be celebrities. So when I found that some of my favorite Sim people became Sim celebrities I was not thrilled. I tried putting up a fence with a locked gate. And that worked to a point. But then my Sim family couldn't invite people over. And they couldn't go anywhere without being bugged by the paparazzi.
It frustrated me to the point where Sims 3 wasn't fun to play at all. So I tweaked Sunset Valley to my liking, by putting the commercial lots where I liked and my favorite pre-saved -- pre-Late Night Sim households where I wanted them. I did this back in November.
A couple things I should note just in case it does make a difference is that I play with aging off and story progression off. Watched what opportunities I choose to do and what jobs my Sim people took.
It's been working so far. I see Sim people that are paparazzi around town, but they leave my Sims alone. And that's what I like!!

So from this I have learned:
1. Install your saved pre-Late Night Sim people/families into Sunset Valley or a town that doesn't have Late Night commercial buildings in it.
2. Avoid jobs that require your Sim person to have celebrity status.
3. Avoid any opportunities that pay in celebrity points.
4. Play with story progression off.
If anyone else has tried something similar and/or has any tips or tricks. Please let me know. I'd like to share our progression on keeping a no-celebrity town.
Thank you,

Mrs Flynn