Here's a few articles and stuffs that might be useful to some of you.
"Improving the Combat 'Impact' of Action Games" - http://www.gamasutra.com/features/20050428/sang_01.shtml
Excerpt of the Book "Create Professional Game Art Using Photoshop" - http://www.gamasutra.com/features/20060622/ahearn_01.shtml (Three Whole Pages! )
"Modular Game Art for Fast Level Design" - http://www.gamasutra.com/features/20051202/mader_01.shtml
"Illustrator-to-Maya: How to Design and Build the Perfect Level" - http://www.gamasutra.com/features/20050607/steingraber_01.shtml
"Tiled Terrain" - http://www.gamasutra.com/features/20011024/peasley_01.htm
GamaSutra Level Design Resource Page - http://www.gamasutra.com/resource_guide/20010716/index.shtml
Misc. Level Design Articles - help.hourences.com/ http://www.gamedesign.net/node/111?PHPSESSID=b9d5fc7f7f9e82a463cc3b84d8f51815
"Watch and Learn Videos - Digital Painting" (DivX Format) - http://www.carloscabrera.com.ar/tutorial.html
"Designing Arcade Computer Graphics" (zipped PDFs) http://www.gamemaker.nl/feldman/full.zip
Tsugumo's Article "So You Want to be a Pixel Artist?" - http://www.petesqbsite.com/sections/tutorials/tuts/tsugumo/
"Creating Good Game Art When You’re Not An Artist" http://www.gamedev.net/reference/articles/article1069.asp
if there's something that i missed please notify me and i'll stick it up here. this will also be added to as i find more articles.
NOTICE: As you can see in the succeeding posts (no offense to Fenryl and Shankar, of course, they were just trying to help ), please do not list link suggestions for "cut & paste" tutorials, since this thread is focused more on design than the "do this, then do that" kind of instructions.
[2010-02-26: Fixed a broken link. -dbaumgart] [Edited by - dbaumgart on February 26, 2010 5:51:14 PM]