To make the spell viable i would agree to either make the automatic dmg a bonus action or to have the upcast dmg for subsequent activations too.

On the other hand, it is "just" a 1st lvl spell. So it is not unusual to get less and less effective at higher levels.