The Custom Formatters module allows users to easily create custom CCK Formatters without the need to write a custom module.
With this module you are not constrained to just node-*.tpl.php templates, anymore. You can create as many tpl.php templates as you wish and assign them to the URL paths you need.
Drupal 6: complex node synchronization with Pubsubhubbub
Drupal 6 with german translation and YAML templates and own modifications
With Drush System Manager you can get your hands dirty with cck and views export files. I use it to get my views and content types into subversion.
Eldorado Superfly is a module that takes control of the "Submitted by..." text, node links, user pictures, and comments. It moves them to $node->content, where they can be re-ordered on CCK's Manage Fields tab. However, this means they are no longer under control of the theme.
External Links is a small module used to differentiate between internal and external links. Using jQuery, it will find all external links on a page and add an external icon indicating it will take you offsite or a mail icon for mailto: links.