Croesus
Adventurer
Compare it to a +1 item, arguably among the weakest but most reliable magic weapons. Assume the weapons both deal 1d6.
Your weapon=1 extra 1d6+mod per day (we will assume mod is 0.) Max damage 6.
+1 weapon= +1 damage per attack. Unless they only attack 5 times, your weapon is equal to or weaker than the +1.
End result, your weapon is not only not overpowered, but is arguably among the weakest possible, discounting anything situational like a sword that allows you to cast Thaumaturgy 1/day.
Sure, it's weaker than a standard +1 weapon, but it's not weak. It allows the wielder to inflict magical damage, bypassing a common form of damage resistance. Once per day, it also allows the wielder to make one free attack with the weapon. Timed well, that attack might down the big bad before it gets one more shot at the party. I like it.
Note: In my own campaign, all magic weapons are like what the OP came up with. I don't give out + weapons. I give out magic weapons that also do something useful. So far the characters are doing fine, often beating challenges above their level.