Hey bro, the Wiki is always a good place to start. It's mainly up to the game style, you can do a can do both on the same texture, some people who hand paint start with a photo source, people who do photo realistic textures, will more often than not hand paint a bit of detail in. Looks like zbrush 2.5 to be honest.…