I personally like the Utlra Realism for the non-motion things. I also would prefer a cartoony or slick plastic look for the motion characters. I'm not big into claymation as a game graphic style unless its all in but even then.
Though I think a good example of part of what I would like look wise is, ironically, Little Big Planet.