Character textures are the single largest category - the editor lets you swap in custom crowds, and themed civilian packs are what most people download. Music packs are a close second.
Ranked by hand, not auto-generated. Every mod links to its full page with install guide + compatibility.