Hotline Miami 2's level editor spawned a huge custom-campaign scene. The Hunter series is the gold standard, but the workshop is full of original multi-level campaigns.
Ranked by hand, not auto-generated. Every mod links to its full page with install guide + compatibility.