The papers coming out with Gaussian splatting and nerf are simply amazing these days. I think the results here are close to being useable for a video game or a low budget movie. You'd still need a lot of human refinement on top of the generated models, but they seem useable as background assets.