I'm playing a mage, currently at level 20, and I haven't had any problems so far.
..and there is the rub.
Get to 40-50 and see how you feel about it. Keep in mind, your spells aren't going to do ANY more damage than they do now. You are causing as much damage with those spells as you will for the entire rest of the game. But enemies will scale up, with more health and more strength....and your spells will still be exactly the same.
That is the point. Destruction DOES NOT SCALE. It's fine at early levels, and even mid-levels (due to spell "upgrades" and perks), but when you get to high levels, you've long since run out of new spells to purchase and new perks to add, and have no way of increasing your damage.
Destruction needs to scale. Period. Everything else in the game does. This is an oversight, plain and simple.
Bethesda can fix this in one of two ways:
1: Create a new set of variations for each spell (Novice, Adept, Expert, Master, etc), which you can purchase as necessary.
2: Have one spell, but have it multiply it's damage based off the Destruction skill level.
Even a combination of both will do.
I realize this will get modded in, but there are a lot of people playing on console who are totally turned off by this. It needs to be addressed officially.