The opening sequence in Up always gets me.
I don't think photorealism is required in video games and in some ways it could be very limiting...once you enter a photorealistic environment anything that isn't done perfectly is going to jump out and break your immersion in the game. Bioware is a good example of a company that does a lot of good things but they can't seem to figure out how to do character model/faces well within the limitations of their technology. Plenty of other companies out there do a better job of making artistic choices that mesh with their technology to create great looking games.
And best wishes on whatever your new endeavor is. Have enjoyed your written and video contributions to Gamespot.