The visual aspect of a website is always important but the add to cart button is quite frequently overlooked. This article :
107 Add to Cart Buttons of the Top Online Retailers gives us the some nice examples for inspiration. This article also has some great tips for cart buttons such as:
Button Placement
If you offer helpful features on your product pages like wishlists, enlarged photos, colour switching, alternate product views, email to friend, size chart, view cart or check out buttons, make sure the “Add to Cart” button is obvious, bright and prominent in comparison. Less important functions can be lighter coloured buttons or simple text links.
My Favourites are

and

from 1800contacts and Proflowers respectivly