Here are some tutorials I've written on techniques I've tried out and luckily haven't forgotten how I've made it ;) All tutorials were created using Photoshop 7, they should work from PS7 and up.

simple tutorials
Icon tutorial ----> dark colors | light colors
Soft glow tutorial

special effects
How to create a hand drawn look
How to create a drawn watercolor style look