I've been following the Warzone 2100 art revolution project for some time now... but after years of displaying only nice renders of cool new models, it finally seems to be getting closer to an actual game integration with the recent integration of GLSL normal-maps etc. into the latest Warzone2100 snapshot.
More awesome (very much work in progress) screen-shots can be found in the Warzone2100 art dev forum (especially this thread) and on the art revolution forum. And while there is still a lot of things to do... an actual Warzone2100 release with a massive graphical update seems not too unlikely in 2011! Lets hope for the best ;)