Beyond character faces, the biggest visual wins are a full NPC and monster texture upscale and an upscaled version of the game's pre-rendered cutscenes.
Ranked by hand, not auto-generated. Every mod links to its full page with install guide + compatibility.