First of all, best wishes for your birthday! I can't answer if GF is for you, but I'm a builder, and I personally use a lot of items from this pack. The more gaudy/rococo stuff works nicely with historical or fantasy builds, while the mid-century items go well with retro, or elderly-home builds. The modern items work with both traditional and contemporary homes, so all-in-all, BB is pretty versatile.
In terms of CAS, there's a lot of nice items, especially if you like historical/fantasy play (from the acting career), or simply want your sims looking like they belong in this century (unlike what's in the base game lol).
Gameplay-wise, I do run into celebrities regularly, but restaurants, provided you have a good kitchen, and a small number of (working) tables (the restaurant I use has 3 tables with four chairs, using couches and coffee tables to act as 'set dressing'), celebs come in, but non-famous sims'll get food okay. You can turn off fame for your played sim/family, and unless you directly approach a celebrity, you shouldn't be affected with the fainting etc.
If you are a celebrity, the negative traits add challenge/fun - unfortunately, the papparazzi can be super annoying. It's hard to go out (eg. to a restaurant) if you're famous, because they're continually taking pictures. When you level up in fame, you can influence sims to do things, like make paparazzi leave, though another one always seems to pop up after.
Re non-celebrity gameplay items (recording station, drone, media station) help storytelling, but you unfortunately can't view or listen to what your sim has created. I haven't tried the acting career yet (although I've had the pack for a while...), so I can't really comment on it, but a lot of people, (including @Elliandre in the comment above :)) have said they like it.
I personally think $24.99/w/ever the us price is isn't bad, but it depends what you want :) .
