One fun way of implementing your idea is adding a large forced movement effect with additional 1d6 damage per 10 feet pushed (where you have Large push 10 feet, Huge push 20 feet, Gargantuan push 40 feet, or something like that).
For example: Make a DC 22 Strength save vs. adult red dragon's tail attack. If you succeed you are pushed 10 feet and take 1d6 bludgeoning damage. If you fail you are pushed 20 feet and take 2d6 bludgeoning damage; and you also are prone if you take any damage on the failed save.
You can adjust damage to taste, but the principle is to include more forced movement from bigger critters and attach additional damage to the forced movement instead of the initial impact. So the dragon can really play pinball with the wizard.