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.
Damn, can't wait to be able to create these things from a simple video recorded on my phone. Amazing.