The Total War series are all very good. Not strictly turn based though.
All the recommendations have been really good. Gal Civ 2 is a fantastic turn based game. Civ 4 is obviously a must have. If you can pick up the Civilization Chronicles anywhere, do so.
The Combat Mission series of games are a good turn based series of games too. Get them here:
http://www.battlefront.com/