My question for those that have experience, is what is it NOT good at? Most comments that I have read so far indicate that it is a little complex to learn in the beginning, but the way it works makes sense after a little study. Some people say it is by default ugly, but sites like TheOnion, MTV UK, et al look pretty good to me.

If you have a particular thing that Drupal doesn't do, please be specific. I am yet to deploy my first Drupal site, so I am trying to be thorough in my research.