I think I meant more about "I can take a -6 on the roll to affect all the guys and risk it not working" or "I'll risk three dice on paradox" for stretching your spells rather than "I can totally cure cancer with life 2, right??"

DND doesn't really have much tactical depth for the spells. They do what they say and always work (unless saved against). You never get the "I don't know if I have another spell on me!" trope.

What you meant I think shows up in DND too. Players being like "can I use mage hand to swing a sword?" or "can I use create water to drown him?" That's more an annoying player problem, but I see what you mean about some systems enable it more than others.

You'd probably really dislike Fate, then, where it's almost entirely based on what the table agrees makes sense for your free form written character traits.