Most of the visual side of XCOM modding is retexture work applied through Texmod, which means it runs alongside gameplay mods without conflicting. It does mean a bit more setup than a normal file drop.
Ranked by hand, not auto-generated. Every mod links to its full page with install guide + compatibility.