3d modeling and photorealistic rendering in houdini
All model and simulation done in Houdini. Texturing done in substance painter. Modeling is not a tuff job for houdini. Its a procedural software so you can easily edit your problem with out changing the whole model. Its easy to do uvs in houdini too.
Substance painter is the boss for texturing with out anu doubt.