I agree, by the time you play your 2nd or 3rd Total War series game, that gameplay loop becomes really stale.

However, there are single scenarios and more targeted campaigns like you suggest in some of the games, I think.