ALIEN's campaign does not have
character continuity, but is explicitly intended for
player continuity using the pregens.
Of the 3 released cinematics (Chariots of the Gods, Destroyer of Worlds, Heart of Darkness), the expectation is players get to carry forward a bit of metacurrency, and they're actually one thematic whole.
I think it just barely gets to "moderately long," however. For some groups, Destroyer alone will be 2-3 sessions; for others, well... my players turned it into over half a year. Chariots has run 3-5 sessions all three times I've run it.
I've not run Heart yet... it's on the agenda for next weekend starting.
Also note: all three expect few, if any, surviving PCs at end. Hence why no character continuity.
Classic
Traveller's
The Traveller Adventure is a roughly 4-12 month campaign, depending highly upon play style and session lengths.
Mongoose's
Aramis: The Traveller Adventure is a rework for use with their editions of Traveller.
Mekton II has two campaigns for it (that I've seen, at least)...
Operation Rimfire is a classic mecha-anime Romance & Action 22 "episode" campaign book. Note that adventures are pretty short - 2-3 pages each... but envision some significant combat time between social encounters.
The other,
Mekton Wars 1: Invasion Terra is (as might be expected from the name) a Tactical Wargaming mode campaign; one can, however, run it as a backbone for a Roleplaying campaign.
And of course...
Pendragon has 3...
The Boy King (TBK),
Saxons! (S!), and
The Great Pendragon Campaign (GPC).
Nobles' Book (NB) is a timeline sourcebook for 1E; it lacks actual adventures, but provides an overall timeline for a Pendragon campaign, as well as landholding rules.
TBK is the 3rd/4th ed timeline sourcebook; it also includes a number of 3-5 page adventures and a bunch of adventure seeds of 1-3 paragraphs.
S! is a prequel to TBK, and uses the same mode, but for fewer years, and introducing a whole culture. It can stand alone, or be continued into TBK.
GPC is a reimplementation of TBK, and includes a few bits from S!.
Land of Giants is another timeline, but this one is independent, and I don't recall it having many adventures within.
While not a formal campaign, the three "
Tales of" volumes form a nice filler for a standalone, and most of the 9 or so total are multi-session...
Oh, and for
WFRP 1e... the
Doomstones campaign is not a great WFRP campaign, but it is a long one.
It's decent, but clearly was ported to WFRP, rather than being natively written for it. it's 6 dungeon crawls. Which, given the realities of WFRP 1E combat and healing, can and will take a long while.