Although the creativity is not driven by the type of software we are using, still it is important to gain the right skills in the right combination of software. During the past few years, I found that primarily After Effects and Cinema 4D is a great combination for medium sized production such as TV Commercial, Corporate and small scale VFX for Film Production. But to put that into a better perspective, here is what I use:
After Effects, Cinema 4D, Octane Render
Mocha Pro, PF Track 5, Redshift Render
TurbulenceFD, Fusion Studio, X-Particles 4, Cycles 4D Render