Curse person

You do an attack with the magical weapon or artifact you have, on a hit, the weapon or artifact shatters and breaks, and the target must make a saving throw based on the curse you do.

• The target loses 1d4+2 to any ability score of your choice, the saving throw is dependent on the ability you choose to reduce
• the target makes a saving throw dependent on the targets spell casting ability, on a fail, you can no longer cast spells and use charges on magical weapons. If the class can’t cast spells, use your intelligence.
• make a constitution saving throw, on a fail, you gain a vulnerability to 1 of any damage type, and loses all resistance or immunities to that type.
• Either the targets strength, dexterity, or constitution score is set to 5 (-3 modifier). The saving throw is dependent on what you pick

This curse can only be dispelled by a remove curse spell on the same level (or higher) as the curse was cast

yes, the magical weapon breaks, but it may be able to be repaired. This will take a lot more than the mending spell however.