In addition:
Deus Ex : New Vision mod for Deus Ex - Mod DB
The HDTP tackles models and objects, New Vision refurbishes walls, floors, computer panels and the likes. It's still a ways away from release, but it looks to be worth the wait. Whether or not this release will support bump mapped textures (there's a screenshot), depends on whether or not they can get Deus Ex to run on less fossilized iteration of the Unreal Engine.
For more info on that particular project, browse the forums of
Deus Ex: Reborn (- the forums -, the main site itself doesn't show much)
It seems likely all three mods will end up being merged at some point, creating something more up to par with the graphics and physics of Deus Ex 2. Very interesting.