> e.g. if they used a seperate rendering package or mostly painted by hand

IIRC Max Payne was one of the earlier games to rely heavily on photo-reference textures (instead of hand drawing or computer generating them). Keep in mind that in 2001 digital cameras were rare, expensive, and low-res, so people often just used film cameras and scanned in the physical photo with a flatbed scanner. Max Payne was far from the first, though; even 1998's Half-Life used some photo-ref textures.

The lighting in Max Payne's textures was probably mostly just the lighting from the original photo. Every texture had to be hand-manipulated to make it usable on 3D models, so changing the lighting would have added even more work and would have looked less realistic.