On a current site in development I am using Ubercart to provide a renewable subscription service. To make the user experience clean, I wanted to protect the user from going 'shopping' to add their subscription.
I frequently use a 3rd party designer to help with the tedious task of going from PSD to final theme. If you haven't realized it yet, but alot of designers have problems setting up a local MAMP install w/ drupal in which to fuck with css.
Image Assist is a great choice for adding images to content in Drupal. This module allows users to upload and insert inline images into posts. It automatically generates an Add image link under the textarea fields of your choice.
The Node Reference module defines a field type for use by the Content Creation Kit (CCK) to reference one node from another. It works very good and allows you to add a greater amount of complexity to your site.
Having built two fairly robust and strongly interlinked taxonomies to aid in categorization, SEO and navigability of my site, I decided I wanted one of those (old school) tag clouds to display my lexicon.
In Drupal you should know that you never want to hardcode a local URL into your nodes or blocks. Firstly as your site expands the node may show from places you do not currently imagine thus breaking your paths.