Fyr had lived for millenia, created life through non-sixual means several times, and subverted the design disease. I get the impression that he's supposed to be godly powerful.
No. The Morrowind mages guild doesn't even begin to compare with the power of the centuries-old magisters of House Telvanni, and all throughout Morrowind, you're constantly being hit over the head with how mysterious the Telvanni are, all reclusive in their towers and whatnot. Because they don't flex their muscles, because they don't waste their efforts trying to build up temporal influence, nobody really knows what they're capable of.
They don't flex their muscles because of their incompetent leadership perhaps? Because they can't put their act together? Yes, Telvanni have potential of being powerful house, most powerful perhaps, but it seems that they have leadership issues, genius-lunatics focusing more on their own goals than in mutual benefits. However if they can put their act together under competent leader (which they have aswell) they probably are one of the most powerful house.