I use Gimp mostly, once I learnt how to tweak it for pixel art it is quite good.
For me all starts with the right palette. It really helps to get what you're looking for. I usually work with 64 colors (unless there's any special restriction, of course).