
You learn an ancient technique to infuse your weapon with a spell for a temporary amount of time. As an action, you can imbue a spell of 1st level or higher, to a maximum of third level, into a melee weapon that you are holding. You can only imbue a spell that targets one creature or a spell that has an area, such as a cone, sphere, or cylinder. You cast the spell as normal, but the spell effect does not occur until after the weapon is used in an attack that hits. The weapon holds the spell effect until the end of your next long rest or until it is used in an attack. If you cast a spell that affects one creature, the next time the imbued weapon hits a creature with an attack, the attack deals damage as normal, and then you resolve the spell's effect against the target. If the imbued spell has an area, the creature does not need to be hit for the spell to take effect. Instead you resolve the spell's effect from the space or creature you targeted. If the weapon hits a creature, damage is dealt as normal. Once you resolve the spell's effect, the spell vanishes from the weapon. You can only have one spell imbued in a weapon at a time.

I'm currently using this, and I think it's great and really interesting concept, I wish the proficiency expanded to simple weapons too.
One point that I foresee, but haven't encountered yet, is silenced areas, I expect this to be that the spell still takes effect because the spell is considered cast at the point of infusion.
Here are some images I made for this: https://imgur.com/a/3oUU8h8
Thanks for sharing it with the community.