Action XChange

Okay, so it is not a tutorial site... but it has a TON of Photoshop "actions" (like macros) for special effects that you can download and then learn from... sort of Interactive Tutorials. Or, you can just use them to do what you need and not learn a darn thing. ;)