NOUPE have made a awesome link collection of top-notch Photoshop tutorials, brushes, patterns, textures, actions and .PSD downloadable files that others have freely contributed to the design community for making your next photoshop effect.
If you're a web designer/developer, there is lots of useful stuff - go get'me..