I can remember playing several older ones but nothing good has come out lately... seems the fps generation has taken over from the grognards.
There are two dream games I would like to see. First is a massive grand strategic simulation of the entire civil war from the economy level to transporting, supplying, and training, and then when combat occurs breaking it down into a battle similar to the Talonsoft civil war series games. The second would be a 3d realtime simulation of the naval aspect of the American Civil War similar to the old Yaquinto's Ironclads boardgame. Lots and lots of detail and stacks of paperwork involved with the boardgame but it absorbed many a night while I was in high school (played some of my teachers) and also in the local wargaming club when we absolutely tired of Squad Leader.