Check out this screenshot (Heroes 3 + Photoshop).

What can I say about the first picture? It could have been better, but the second and third ones clearly require talent: I doubt I could draw something like that without an original.

Added 5 minutes later
The fourth picture could have been made more realistic. If you want, I can do it myself: I have plenty of experience with Photoshop, and I can draw pretty well too...