Preffered melee weapons for Mage builds

Good day to you fellow High-Intelligence Undead!

Just looking for some input on what melee weapon to offhand for the occasional necessity of it. I'm currently just getting into Anor Londo and feel as I approach late game I should get a better melee weapon for when I might need it.

I got myself a divine Morning Star to help clear through the Catacombs and Tomb of Giants with a bit more ease, no one likes extra skelly-bois running around. After that I just never switch off of it.

I've got what I need to make the Moonlight Butterfly's spear which I've heard is good, but I wanted to inquire with the community about my choice. Is the Moonlight Spear fine? How would it compare to another weapon that I could ascend to Enchanted? Or would going Magic weapon be a better route? What's a good deciding factor between those if any?

Thanks for any advise!