Texture work is the single biggest category by downloads here, and two authors account for most of it. Both approaches replace the game's original textures with higher-resolution versions rather than changing the art direction.
Ranked by hand, not auto-generated. Every mod links to its full page with install guide + compatibility.