Really depends on what your objectives are. You are talking like a programmer, not a writer.
Content strategy dictates the CMS. It ain't the other way around. It especially isn't the one CMS you specialize on.
Without content creators, there would be no need for a CMS. Yet surprisingly, this user group is often the worst served by a new content management system.
— Knowledge management consultant James Robertson
You need to know a range of CMS packages to recommend the right one for the situation. Each has strengths, weaknesses. What you are asking is the "answer from the back of the book."
For example, there's a CMS that is not bad for video. It's not well known.
There's another for adding a simple editor window clients can log into, and you can add very easily to any Div-based design.
Drupal is good for a community based site. Joomla is not bad for a single organization portal. Wordpress is good for putting up pages of content. Depending on your content strategy, any could be useful.
Despite protestations to the contrary from every one CMS shop, no one is good at being everything to anybody.