Weem, rather than giving specific game or adventure details I thought I'd just list or categorize a bunch of Theme Types and let you work out the specific game, adventure, and campaign details. Most of these campaign types it seems to me are self-explanatory. If not I included a little note.
Historical Campaign
Alternative History Game
War or Wargame Campaign (Offensive Warfare)
Invasion Campaign (Defensive War)
Ethnic Cleansing Campaign (Genocide)
Quest Campaign
Personal or Character Driven Campaign
Psychological Campaign
Thriller Campaign
Criminal Campaign
Law and Order Campaign
Hunt Campaign
Monster Campaign
Geographic Campaign
Political Campaign
Mystery/Detection/Investigative Campaign
Academic or Scholarly or Research Campaign
Transferable Skills Campaign - relate game to real world interest of players
Achievement Campaign - first one ever to do it, or one of few to ever do it
Mythological Campaign
Status (Kingmaker) Campaign - where one of more players seek power, status, wealth, or influence
Legacy Campaign - fulfilling a personal or family legacy
Heirloom Campaign
Religious Campaign
Ritual Campaign
Occultic Campaign - hidden or secret knowledge
Horror Campaign
Diplomatic Campaign
Agency Campaign
Clash of Forces Campaign - clash between opposing groups, powers, interests, or parties
Nemesis Campaign - campaign against your nemeses
Illusion Campaign
Magic or Change in the Nature of Magic Campaign, also called an
Arcane Campaign
Nature or Environmental Change Campaign
Fate Campaign - one or more party members has a particular Fate to fulfill
Scientific or Technological or Invention Campaign, also called a
Progress Campaign - where some scientific, technological, magical (a new spell or device or artifact is created), or invented machine, device, artifact, or discovery threatens to fundamentally transform or alter the world
Geographic Campaign
Relical Campaign - involving some ancient and powerful relic, artifact, or ancient device
Disaster or Catastrophe Campaign
Discovery or Exploration Campaign - discovery of some new area of the world, or of some ancient yet unknown/little known section of the world
Heroism and/or Self-Sacrifice Campaign
Disintegration Campaign - slow disintegration of a structure or system or government or a nation
Rebirth or Renaissance Campaign
New Race or Species - discovery of a new race or species
Weird Campaign