Because the PC port shipped with compressed 720p cutscenes, the biggest visual wins are upscaled story movies and full character redesigns.
Ranked by hand, not auto-generated. Every mod links to its full page with install guide + compatibility.