Image formula fields have been out for a few years now, but a lot of people still don’t realize the power of them.
Image formula fields can be used to set product photos, stock charts, priority flags, photos of contacts, etc…
There is even a free AppExchange component that demonstrates a number of these examples.
http://blogs.salesforce.com/blogs/2006/01/prebuilt_image_.html