I think people using "god like all power forces of nature dragons who are also wizards" actually spoils them a bit. Dragons should be strong and scary, but not SO strong and scary that you can only use them as god-like threats that 99% of players will never reach. I prefer them "weak" and common enough that you might actually fight one occasionally and the DM won't be so scared of letting you befriend one or even become a dragon rider at some point as a high level campaign goal.

While I get why people do it I personally have a bit of a pet peeve against spellcasting dragons because, to me, the entire point of dragons is they are the strongest PHYSICAL threat out there in a standard fantasy world. It's something you must overcome with great force, where as the strongest MAGICAL threats are different kinds of creatures requiring much different means to defeat, like a Lich or Wraith that keeps coming back from the dead and requires magic to beat once and for all. Dragons are arrogant enough that they only trust in their claws, wings, and breath. I get why people give them magic though since if they're smart and evil it's an easy force multiplier, I just don't like it personally.