PS is good (but again the "tool" is only part of the equation)

Painter is also great for replicating "traditional" media effects (ie. paint brush strokes, pencil, chalk...)

there is also a really cool free app called ArtRage, and i hear Microsoft aquired CreatureHouse's Expression

others may have different opinions ;)

:)
retrocity