Pixar has a house style, with procedural textures, written in Renderman. Everybody else mostly takes pictures of real world stuff and uses those as textures. Pixar's approach has the advantage that the camera can get very close to a surface without the texture going blocky. "A Bug's Life" and "Toy Story" use this heavily. Wouldn't help in making an Avengers movie.

Here's where that procedural texture approach started: "Road to Point Reyes".[1] First "photorealistic" render, 1983. Today, that's not even an acceptable game asset.

[1] https://lucasmuseum.org/works/detail/asset_id/1292