Civil War Bull Run has good AI (tactical game.)

You aren't likely to see good AI in many games for the foreseeable future.

Why? Each time you build a new game engine, you need a new AI. AI takes lots of time to perfect and its a lot more challenging than doing pretty artwork or 3D models. The money is in the flashy graphics and effects, not in gameplay.