Here's my take on a couple of perennial Shadowrun favorites:
Urban Renewal, and Turn to Goo!
Urban Renewal (aka Summon Heat Penalties) causes destruction, so probably ought to be classified as a Combat spell. Although IIRC back in the early editions it was Manipulation? Whatever. Damage=Combat spell, by my rationale.
Ingredients: Area Effect (+1DV), which must included Ranged (+1DV)
Narrow Target (buildings and walls) (-1DV)
Wallop (+1DV) (because we want to do physical damage to walls, not stun them

Weaken barrier ratings (+XDV) (because, well, we want to actually KNOCK THOSE WALLS DOWN)
So, without the effect of softening barrier ratings, we're at 3DV for the spell. Let's go nuts and make the demolitions work rather well and subtract 5 from affected barrier ratings!
End result:
Urban Renewal: Area, Ranged, Type P, Duration I, Drain 8 (lol) This spell only affects walls and structures. Reduce affected barrier ratings by 5 before applying damage.
and:
Turn to Goo! This is clearly a sustained manipulation.
Affect Living Things (obviously) +1DV
Petrification (being turned into goo is kind of like being petrified? doesn't make much of a difference, when you look at the petrified status rules) +1DV
Ranged (even though it's free for manipulation, this is clearly an offensive/hostile spell, so pricing it like combat here) +1DV
That adds up to 4 drain. still not a whole lot for what's essentially "I win". Probably have to score [BOD] net hits over and above the resistance in order to turn someone into goo. or you can only sustain the spell for 10-BOD rounds, or something. Yeah, I like that better. That way being Turned to Goo isn't automatically death.