Olleus
Deity
There is of course Age of Wonders or Heroes of Might and Magic, which use a seperate Tactical Combat to resolve battles between stacks. Adding something like that, however, immediately makes a game much more war-focused, while Civilization is special in that it focuses less on war than most games of it's kind.
That's true. The entire Total War series and even Sid Meier's Pirates also have a different strategy and tactical map. It's hard to see what kind of tactical map setup could work for both archers and tanks however.