Drupal allows very fine grained control over how content is presented to the end user. The presentation layer is abstracted beautifully and cleanly designed hooks allows for moving data from the logic layer to the presentation layer.
Views is one of the most complex of all Drupal modules and one of the most useful of all Drupal modules. The only downside is that, since it is very complex, not too many people have been able to contribute to the documentation of the module.
SEO requires you to have descriptive titles and URLs matching the title. But when you want to publish your URL some place where the length of the URL is an issue you definitely want short URLs.
If you create anything other than a very small site using Drupal you will end up using Views and CCK, two of the most important contributed modules in Drupal.