I would recommend checking out the following sights for photoshop tutorials/work.
The first two links are probably the highest quality tutorial sights I have come across.
^^ Great magazine to subscribe to. The issues contain a ton of in depth tutorials from professionals, work from the community and pros, as well as a disc with tutorial, brush, texture, and other content.
Hopefully that helps.