Long read, but a good one ;)

If a site needs some real complexities and has future issues of even more complexities Joomla is probably a better place to be.

I would say, better go with Drupal...