One of my favorite ideas for a fantasy doomsday weapon is from a Larry Niven story. In the story, the world has wizards able to wield mana, which is a consummable resource. One wizard creates an disk of metal that cannot be shattered. The disk use mana to spin. The faster it spins, the more mana it consumes. Once set in motion, it eventually consumes all magic in the world.