Just like to add that a way cheaper and smaller compact camera with builtin auto zoom lens is enough,
as long as it provides a lot of zoom (about 15x and upwards).
Pixels don't help when the object is out of focus.
And I once heard that smaller ccd chips had a better signal to noise ratio.
Better for traveling, too.
The more optical (!) zoom the better, and it is best to disable digital zoom right away...
Happy texture sniping