XCOM's mod scene grew around Long War, a fan overhaul so large that most other mods are built to sit on top of it rather than replace it. Expect to read install instructions carefully, since load order genuinely matters here.
Ranked by hand, not auto-generated. Every mod links to its full page with install guide + compatibility.