Outcast , open world with raycasting and polygon engine, dof reflective rippling , translucent water, particle effects and everyone's favourite bloom and lens flare.
there was a claymation game who's name I can't recall the gameplay wasn't great but it looked good, also the already mentioned soul calibur and Shenmue.
Edit. forgot MDK .
Do you mean The Neverhood?
Heart of darkness was very good looking as well