I will try to answer this to the best of my limited knowledge and abilities.
The way I see this question is that it has three separate parts. I will try to answer them, one by one.
You asked: Does Gandalf have very limited powers compared to what we think of wizards today?
I don't exactly know what you mean to say by this as most of the things that Gandalf did (or Tolkien have him do) are reused by other wizard characters in literature today. If Tolkien got it from somewhere else, he reshaped it and reused it in an entirely different and modern way which made it unrecognizable or "hard to spot" as it were in it's true origin. Tolkien reused many of the items and things that wizards in literature and stories did in the past, but he reshaped it into a more realistic form.
If we were to compare Gandalf to Harry Potter (or any other magician or wizard) or J.R.R. Tolkien to J.K. Rowling (or any other writer), we would probably end up in a discussion. Personally, I don't think the two are comparable as I wouldn't think to compare LOTR to any other kind of literature or any other kind of literature to LOTR.
Having said this let me try to portrait Gandalf as a Wizard in today's day and age.
The Istari (Men called them Wizards) took the form of Men, but
possessed much greater physical and mental magic power. For over 2,000
years, Gandalf worked most faithfully against the rising powers of
evil in Middle-earth.
As we can clearly see from this statement, Gandalf wasn't a man, but another more powerful being than a man. Other Tolkien ripoffs portrait the magicians/wizards as men. Thus, making Gandalf more powerful than them from the very beginning of their creation. Men cannot take forms, some do with magic, but we know that Maiar can and have taken many forms and shapes even as other beings or entirely other creations. Men (magicians/wizards) only took the form of an animal, through magic, by learned magical practices or spells. Gandalf lived more than 2000 years, which magician in other fantasy literature lived this long?
Gandalf was not just powerful, but also the wisest of the Maiar (note - not just all of the Istari (known to us as Wizards), but also all of the Maiar). Men know him as Gandalf, but he was first known as Olórin, his first Maiar name.
In the terms of the race of Maiar, Istari (Wizards) is merely a culture and a way of life. I see it as mister Tolkien invented a whole other concept of magic that depends on the forces of the being itself, while also depending on the forces of nature and the doings of good or evil by that being. Gandalf was the first magician/wizard that did good in literature, all the others before him did corrupted, bad and evil deeds with magic for their own enrichment, greed. They did the filthiest kinds of (black or other kind of) magic and wrong doings towards their fellow man or animal (or other being). Gandalf was the first one in literature (to my limited knowledge), the first one to only do good deeds for the well being of the world he was placed in, the purest of them all. As you may recall, he didn't even want to touch The One Ring spawned by black magic and who knows what else, in fear of what it might do to him, in fear of corruption. He only died (as a man, in his retaken man form) fighting another Maiar, and was brought back, for a brief time, to continue his journey/mission of ridding the world of evil again.
You asked: Comparing Gandalf with other wizards spells: fireballs, healing, magic items creation, teleportation, etc.
Gandalf the wise they called him, for he was the wisest of them all. Gandalf used his wisdom first and foremost, then his physical force - being his body, his staff, sword and finally his spells. Wisdom was his strongest weapon, he wielded it like no other magician/wizard.
In The Hobbit, Gandalf used a lightning strike on an orcish horde, which came out from his staff. There we have the lightning strike spell.
Also in The Hobbit, he made the pine cones catch fire with a spell, and used them as a throwing weapon. Hence a fireball.
Also in The Hobbit, Gandalf used his voice to mislead orcs. Could we call this and alteration of his voice or a ventriloquism spell, I will leave it up to you.
Both in LOTR and The Hobbit, Gandalf spawned a light orb on top of his staff to light the way for Bilbo's company (in The Hobbit) and the Fellowship (in LOTR), I guess that we could call this a illumination spell intertwined with an enhancement spell. He also does a similar thing by blinding the foes at the gates of Minas Tirith (from the movie), as we could call this a blinding spell or a beam spell.
In the same place he used a spell and stopped Balrog from crossing over, using his own body as a shield with a spell and chanting the Flame of Anor.
When Gandalf was fighting Saruman in Orthanc, he used his staff and his body to push him back and cause him physical pain - presumably outside and inside of his body, even his internal organs. We can resort to some magical psychokinesis/telekinesis here.
Gandalf healed the main eagle Gwaihir the Windlord, we can resort to healing skills, powers or spells here. We could also say that he had something to do with his second life as Gandalf The White, or being brought back from the dead.
We may also add some sort of a charm spell used towards Shadowfax, his horse, and maybe even some of the great eagles.
Dual-wielding a staff and sword, was first used by Gandalf and not other magicians/wizards. The sword Glamdring, was only in his use after he found it in the troll cave and not before.
As far as magic item creation goes. We could say that gandalf enhanced his staff by magic on occasion, and also the Glamdring sword to an extent when needed, as in the case of the Balrog incident.
Teleportation (to my limited knowledge) is always done with the aid of something, not just a simple spell. Sometimes it is done in the form of a portal or gate. In the case of Gandalf - well, what kind of book would LOTR have been if Gandalf had teleportation means of his own and then used them to teleport himself (they wouldn't need a Fellowship) or even the sole Ring past the Eye of Sauron and every orc and creature inside Mordor into the fires of Mount Doom?
(note: there are many more, but I cannot recall them all now)
You asked: Gandalf seems much more sword oriented than spell oriented. Were the ideas of a wizard not consolidated at the time of writing or is Gandalf a lot more powerful than he seems to be?
I think the answer lies a few lines back in this answer, but I will attempt to answer the second part of this third and final question.
Keep in mind that Gandalf (in man form) as Gandalf the White had far more powers which we don't know about; as the story came to an end and we didn't find out.
I apologize, but I cannot recall any single mage/magician/warlock/wizard (in literature, game or other form) who only used spells and nothing else - spawned/replicated food, teleported to who knows where, flew all over the place without the aid of a dragon, a gigantic eagle, or other being. I cannot recall a single one that didn't eat and relied entirely upon himself, his own being for food, existence and protection. It is known that all wizards use wands, staffs and swords. One might consider them as light weapons to carry but also as powerful tools and weapons in the hands of magicians/wizards. Wizards/magicians are also known to use their fists for striking with, or casting spells or even as psychokinesis/telekinesis aid.
These are all tools that Gandalf used along with his own head, his wisdom and knowledge of all things he acquired as a living being and a traveler through his life(s). For him, wizardry and magic was more than just a means to an end, it was a deep cultural act, but also a heavy responsibility towards all beings, an appropriation towards doing good.
Hope this answered your question(s).