The SandsAutoBody.com website design and build was my first real foray into using Drupal 7 for a client project, and I am glad to say it exceeded my expectations.
The original site brief called for a number of addition functions to allow user interaction with the site. Many of the requirements where fulfilled by the excellent Drupal community of module developers.
This site also signaled for me a site that was constructed using extensive custom Views, these are custom database queries that you can use to control the elements that are used to construct the page or a sidebar items.
The main features of the site are the image upload for estimates and the custom Gallery that was created using a combination of Gallery Formatter and the veritable Swiss army knife module that is Views. The view allows the site admin to upload a number of images to be contained in a grouped gallery where images can be selected for larger views. Obviously, the system takes care of all the image resizing automatically when they are initially uploaded and imported.