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.