I've been doing some work on a new site for the OSUOSL using Drupal 6. Of course, I can't take all the credit, Greg has been doing the majority of it, but I've been pretty excited to dig into it when I can. Our future site (coming soon, stay tuned!) isn't overly complicated, but we're able to achieve some cool things using Drupal core and a handful of additional modules.
With a combination of Drupal Views, Content Construction Kit, and Content Templates, we can easily create some pages ("views") which aggregate a certain content type and display them in a customizable way. One example is our list of hosted projects and communities. On our old site we have a large page body which contains text for all the projects we host. This can get a bit hard to manage since the list has gotten rather long. For the new site, we've created a "Community" content type, so each project/community actually has it's own Drupal node. Adding a community is just a matter of creating a new node with the community content type; editing is just as easy. We then have a view which shows all published community nodes, and manipulate the way those nodes are output using a content template. Having the communities all stored separately gives us some more flexibility to do other things with that data. For example, we can query all community nodes in order to display a random subset of them on our home page.