You asked about Get to Work and Get Famous (I don't have Eco Lifestyle). I'll give you the low down for future reference. Get to work comes with four careers: business owner, cop, doctor, scientist. I enjoy the careers, but if I'm not playing one of them, it really doesn't add much to the game. So it's not a good all-around game play pack.
Get Famous is different. It adds fame and reputation. Reputation applies to everyone. It's kind of like Seasons in that sense. Based on whether you direct your sim to be nice or mean to other sims, their reputation goes up and down. If you've cultivated a nice sim, other sims are excited to see them, they get an immediate relationship boost when they meet new people. If you have maximum reputation, you can throw a charity gala. If you have a sim that you direct to be mean, their bad reputation causes people to be frightened of them, and they can make instant enemies when they meet new people if their reputation is bad enough. For me, I love it when sim behaviors have consequences, and it wouldn't be the same game without reputation. Fame is also a good all-around feature, because you can earn fame through so many activities, not just the skills that come with Get Famous. You can become a famous writer, painter, photographer, comedian, musician. Most of the base game hobbies can earn you fame. There's also a fame perk tree where you can spend fame points on special advantages.
