Neverwinter Nights has one of the oldest modding scenes on PC, and the most-downloaded content is still custom campaign modules written for a single player character. The Gladiatrix series is the standout here — three connected modules following one gladiator's career.
Ranked by hand, not auto-generated. Every mod links to its full page with install guide + compatibility.