Play Heroes of Might and Magic 4 or 5. Both battle systems are based on hexes. The strategic map gameplay is turn based like Civilization, requires resources and gold per turn, and you can build buildings in each town to upgrade it. Battle system is hexed base like mentioned. Melee units are in front of ranged units. Heroes have spells to augment the battle (like direct damage, stuns, buffs, debuffs, teleport units past obstacles, etc). The entire system is based on protecting strong ranged units with strong melee units at choke points on the hex field as I imagine it would be like for Civ 5. It's a great system and requires you to make decisions such as putting X many units in a 3 man formation infront of the ranged unit to protect it from top, middle, and bottom areas. Check it out if you havent.