Cgsociety has an awesome 3 page article featuring the making of Spiderman 3. includes: some of the effects and techniques they used on the film, the tools they used to create the sandman, and how the evil goo effect was conceived. Warning there are some spoilers.

Full Story:
SpiderMan 3 Visual Fx