Magic isn't great for the DLC areas. My suggestion is if you don't want to spend a soul vessel, burn a bonfire ascetic at the third bonfire in tseldora which is the area before Freja, and fighting Freja a second time. You get a new soul which you can take to ornifex and have it turned into the moonlight greatsword. It's a really nice sword, but the best part is the scaling is an A in intelligence so a Mage can wield spells and deal decent damage up close if needed. If able, infuse it with magic from mcduff and the scaling goes from A to S. If you get it to +5 and have about 50 intelligence, the thing hits like a truck lol. It's easily my favorite weapon in the game.