https://gamesartist.co.uk/photosniper/
Wrote an little article for the Games Artist where I am sharing modelling workflow, talk about, goals, software, ref, blockout & modelling, UVing, baking, texturing, rendering and lighting. I hope it was not a waste of your time!