I’ve tried to collect a few photo effects tutorials that are very much centred around one subject rather than a complete photo manipulation. If you don’t like the finished product I’m sure you’ll find some cool techniques to do certain effects in these tutorials.
Texture Lovers has some great free textures for use in your photo manipulations too.
How to Turn Humdrum Photos into Cinematic Portraits
Dance Photo Manipulation
Water Effect Photo Montage
Create A Vibrant Image Using Photoshop
Creating a Vector Composite Effect from a Photo
Beautiful Lady Light Effects
Create a Flaming Photo Manipulation
Create a Sparkling Fantasy Photo Manipulation
Electrifying Energy Beams
Create dynamic distortion effects
Use lighting Effects To Make Photos Sparkle
This one isnt really a tutorial beacuse it doesnt supply any of the assets to complete it, but i thought id ad it here to serve as inspiration.