Someone's said it already, but I'll say it anyway:
Rise of Nations. It's an alright RTS not too dissimilar to the Age of Empires series, save for that there is more emphasis on economy and macro. Also: your civilisation can progress from the ancient times to the space age.
In any case, it has a Risk-like "Conquer the World" game type where you pick a civilisation and play on a giant map of the world, taking turns to invade a new territory (and doing some other stuff), which must then be captured by winning a typical RTS scenario. Certain territories have different resources that are provide economic, technological or military benefits in the RTS battles . While most of this gametype is still about the RTS, there is still some weight with the turn-based gameplay, such as placing armies, using wealth (accumulated via controlling territories) to forge alliances, trade or add defenses to your territories.
Essentially it's Risk, if instead of rolling dice to see who wins battles between plastic figurines, you play a game of a half-decent RTS.
EDIT: You say in the OP you want a singleplayer campaign. Well, you might want to avoid Rise of Nations then. Because even though it has that Risk-like game mode, it doesn't have a narrative campaign sequence of scenarios like I imagine most RTS games do. It's just one-off skirmishes with the AI or human opponents, that aforementioned 'Conquer the World' thing, and a pretty bland tutorial.
In short, there are no characters, no narrative, and no story.
Rise of Nations. It's an alright RTS not too dissimilar to the Age of Empires series, save for that there is more emphasis on economy and macro. Also: your civilisation can progress from the ancient times to the space age.
In any case, it has a Risk-like "Conquer the World" game type where you pick a civilisation and play on a giant map of the world, taking turns to invade a new territory (and doing some other stuff), which must then be captured by winning a typical RTS scenario. Certain territories have different resources that are provide economic, technological or military benefits in the RTS battles . While most of this gametype is still about the RTS, there is still some weight with the turn-based gameplay, such as placing armies, using wealth (accumulated via controlling territories) to forge alliances, trade or add defenses to your territories.
Essentially it's Risk, if instead of rolling dice to see who wins battles between plastic figurines, you play a game of a half-decent RTS.
EDIT: You say in the OP you want a singleplayer campaign. Well, you might want to avoid Rise of Nations then. Because even though it has that Risk-like game mode, it doesn't have a narrative campaign sequence of scenarios like I imagine most RTS games do. It's just one-off skirmishes with the AI or human opponents, that aforementioned 'Conquer the World' thing, and a pretty bland tutorial.
In short, there are no characters, no narrative, and no story.