I tried it out a bit last night, and it was pretty fun. I was able to get my actor promoted a few times and he became a 1-star celebrity.
So far, I've seen people crowd around Thorne Bailey and Brittany Cho, but it hasn't been disruptive. Maybe if I play a bit more it'll show, but last night it wasn't a problem when my sims ate out and went to that lounge in Del Sol.
I also haven't played my regular saves yet so I don't know how it affects the game when you're not pursuing fame.
Oh, and I also have to mention that I turned fame off, so that only sims actively seeking the spotlight will get famous.
