This video tutorial is a great example of how you can utilize the power of Views 2 Relationships in Drupal. This is a great new addition to views that allows you to cross-reference content types and their fields.
This quick little video tutorial from the guys at DrupalTherapy shows you how to easily make a calendar in Drupal 6.
This blog post will show you how to properly setup the Ping.FM module on Drupal 6. The documentation is pretty poor and setup took me a bit of searching. The runaround was worth it thought because I had the opportunity to learn a little bit about how the Ping.FM API works.
The following is a list of essential modules for creating a blog site using Drupal 6. I figured I would go ahead and create this since I couldn't find much when I did a Google search for "cool modules for a drupal blog".
This is a screencast demonstrating Page content creation and modification using Drupal 6. It also shows IMCE and TinyMCE (WYSIWYG) in use.