Another fascinating battle I just remembered was the German 1918 offensive (Operation Michael). The Germans put the stosstruppen tactics developed on the Eastern Front to good affect, and threatened to burst the whole static Western Front wide open. I suppose one could liken this battle the the Ardennes Offensive in that Germany was essentially playing its last card. Michael, however, I think had a much greater chance of success than the Ardennes Offensive did. As an aside, the only movie I know of that covered this battle (at least a little) was the very good WW1 aviation film 'The Blue Max'. Also, I think by the time they did this film, actor James Mason was becoming typcast as a German Commander.
BTW Treale, concerning Cannae, the Rome: Total War game had a good quote about Hannibal - "Hannibal knew how to win a victory, but not how to use one." How true.