There is a wide variety of art styles available to 3D artists and game developers. These styles can range from ultra realistic styles such as in Far Cry 5, to more stylized variations such as Back To The Future or The Walking Dead. The spectrum from realism to stylized is large in terms of look, feel, and technological implementations to achieve those outcomes. Furthermore, stylizing the models and animations enhance style. An example of a highly stylized game is The Legend of Zelda: The Wind Waker.
An example of a realistic game is Far Cry 5.