That would be the low magic ones.
In the more high magic or superhero universes, magic users with the firepower of a light artillery battery or worse aren't that uncommon.
Then, besides issues of sheer destructive capacity, there are probably even worse sanity and legality problems involved in...