Settlers II 10th Anniversary is epic. Settlers VI is ok I guess. The formula just got worse and worse. But VI became a different game entirely. VII looks alright but not quite what you're after.
The tech you've got is the tech you've got. So not really Civ/Total War like. And nothing has battles like Total War.
The only "big battle big tech" game I can think of is Supreme Commander, but SC2 is just out and absolute bobbins.