Mentioned this to you before, but I’ll repeat if it’s gonna get everyone’s attention
DMG provides guidelines for spell creation, but only for damage output.
What about spells that impose conditions?
And what of damaging Concentration spells, like Sunbeam or Vampiric Touch? Simple reality check, find the lowest level spell that applies the condition you want or close to it, and treat it's effective damage as the rating on that spell level in the chart.
Example: Stunned. Hold person paralyzes at 2nd level, that's a decent comparison.
— Dan Dillon 👥 (@Dan_Dillon_1) January 20, 2020