To good, great, dramatic, etc. effect
Definition 1 of 1
Pro Tip 1/3Context Matters
The effect achieved often depends on the situation or purpose of the action. 
He told the story with such dramatic effect that everyone was on the edge of their seats.
Pro Tip 2/3Subjective Impact
What is 'good' or 'great' can vary based on personal judgment or impact on the audience. 
Her use of humor brought the speech to life, working to great effect.
Pro Tip 3/3Visual Impression
Consider the imagery or visual aspect when applying 'to dramatic effect'. 
The costume designer used colors to dramatic effect, highlighting the play's themes.