True about CG (Avatar has the most advanced CG ever, and it still looks very much cartoonish), but the examples I've posted are miniatures, not computer generated imagery.^No it isn't. The constant use of CG was very noticable to me in King Kong and Terminator 4, too. The CG was great, no doubt, but it was clearly not real.
However, the closest anyone got to making CG look photorealistic was ILM with Davy Jones ("Dead man's chest")
