I've run an illustration/design studio for over 20 years. Carrara is my core 3D tool for many projects. Some projects aren't a good fit and I do use alternatives like Vue, Modo, C4D and Poser. 

I can tell you that Carrara, especially if working with pre-rigged content is important, is the most flexible. Projects that cause me to switch to c4d, modo and Vue usually use features unique to those programs or involve animation work requiring a commercial render farm.

Without sharing details, I can tell you that Carrara has been used on several televisions shows and for Super Bowl bumpers. It's no slouch. ;-)