This mod uses some small SDK tweaks, as well as the unit combat attack defense mod, to convert Civ4 into an entirely tactical game based on ranged combat.
Details in this thread.
Details in this thread.