Hey I never get impressed of the results from all sprite/tile tutorials on the net. I want to learn how to draw good looking sprites ala Final Fantasy, Castlevania, Mega man etc.. any books or online tutorials to recommand?

Well first you need a good artist. There shouldn't be any problems with any of the tutorials on the web they all draw the sprites as well as the artist has drawn them.

First of all, you need to read "So you want to be a pixel artist" by Tsugomo. You can get it here: http://www.zoggles.co.uk/asp/tutorials.asp?tut=17
After you're done with that

Now, here's some other great tuts:
http://www.spriteart.com/tutorials/03_rpg_enemy.html - RPG enemy tutorial
http://www.zoggles.co.uk/asp/tutorials.asp?tut=6&page=14 - Brickwork how-to
http://www.zoggles.co.uk/asp/tutorials.asp?tut=11&page=29 - Wood
http://www.zoggles.co.uk/asp/tutorials.asp?tut=5&page=13 - rocks
http://www.zoggles.co.uk/asp/tutorials.asp?tut=7&page=15 - spiky hair
http://www.zoggles.co.uk/asp/tutorials.asp?tut=3&page=11 - grass tile
http://www.spriteart.com/tutorials/04_rpg_summon.html - dragon

HTH,
Destron

Your link appears to be broken.

Your link appears to be broken.

Probably because it was from nearly 6 years ago

[quote name='PlaidHat' timestamp='1298072478' post='4776139']
Your link appears to be broken.

Probably because it was from nearly 6 years ago
[/quote]However -- if you want to put a minimal effort into helping yourself find the tutorial in question, a Google search for the title of the tutorial appears to produce pages of results which are all mirrors of the same material.

Having used it myself, I gotta say that it's an excellent resource for people interested in doing low-resolution sprite art. However, now that even 640x480 is considered low-resolution, it's probably much more effective to use pre-rendered sprites like in old-school PC games. (Starcraft, Diablo, etc.) You model the sprite once, animate it once, then you can generate frames in all directions with as many keyframes as you want. Takes some work setting it up (you want the camera and the light to be positioned at the same place for all renders, for example) but it's no big deal.

http://tutorialblog.org/pixel-art-tutorials/

Some links are broken also but good source