I wasn't sure by your posts if you had purchased Ambitions yet or not. I just wanted to add my two cents.
I don't normally take up the inventing or sculpting skills, so they haven't really added to my gameplay. Though, when I do dabble in them, they are fun.
Some of the professions are great; some are just plain aggravating. I HATE the Architectural Design profession because it is impossible for me to get a good rating. Same with the Stylist profession. But if you like remodeling houses or dressing Sims, you may find it interesting. I prefer the Investigator and Ghost Hunter professions.
If you are an earth-conscious person like me, you will greatly appreciate the Eco-friendly trait. It's awesome for my Sim to get moodlets for conserving water, riding a bike, and gardening. Two other cool features are laundry and bake sales.
Overall, I'd recommend it.