"Lord of the Rings".
The special effects were great, but in that big battle scene in the latter half of the movie, the strategy stank. What gave the good guys the idea to do a cavalry charge against the enemy army's front?! They should have used infantry to focus their attention away from the castle, then used cavalry to shatter their flanks.