Freelance illustrator,concept artist, and story-board artist Vince Chui has an amazing painting style in Photoshop. Here is a tutorial he did showing his sketching & rendering techniques...seeing someone with his talent gives me drive!!!
youtube , or vimeo. Stop by his website, deviant, or coroflot, to check out more amazing work.