During last week's live questions session on Podtoid, a bunch of you asked me to do a tutorial on how to make sprite artwork. What a bad idea! I'm flattered that people thought Constructoid and Runner looked OK, but if you want to learn right, you should learn from the professionals.
This how-to video on River City Ransom: Underground is a much better showcase, especially if you plan on sticking to more well-known art tools like Photoshop. That said, this kind art isn't easy to make, no matter of how "retro" it may look and no matter what tools you use. It's how you put each creative decision together with the last, making them work as a cohesive whole, that makes the difference between successful artists and those floundering in the shadows (like myself).
River City Ransom: Underground [Kickstarter]