Celebrim
Legend
Systems we call "tactical" often reward conflict avoidance and/or risk minimization - so that the way to success is to only engage in conflict when you know you can win, and the result is a foregone conclusion. Smart tactical choices minimize risk of harm.
This, pretty obviously, is about the opposite of generating satisfying drama, which counts on characters engaging in conflicts we are unsure they'll win. Satisfying drama calls for high-risk, high-reward actions which are often disincentivized by tactical systems.
Again, I disagree. Generally speaking, almost all heroic fiction involves placing the characters in situations where it seems impossible for them to win and where the direct and obvious approach will simply fail, and then has them heroically and cleverly come up with a solution which minimizes their risk of harm and maximizes their advantages such that they are able to triumph despite the odds being against. This is "Now if I only had a wheelbarrow" moment in "The Princess Bride". The dramatic solution to the guard of 30 men at the gate isn't for the heroes to charge forward and overwhelm them in a direct (untactical) attack, because then they were never in any threat to begin with - they simply have the power of plot or superheroic power on their side. The dramatic solution is the tactical solution and it is always the job of the writer to ensure that, whether we are playing an RPG or watching "Star Wars".