this really depends, are you talking reality or fantasy. in reality we don't really keep track of 'powerful witches and warlocks' we rely more on knowledge to determine these things. in terms of spell casting, hard to say, no ones spells work 100% of the time, different factors can effect each spell. high magick can be done by anyone who can charge and focus, it just carries greater risk than low magick, so it takes practice.
if you mean fantasy, i've always been partial to Merlin, but the sisters from Practical Magic brought someone back from the dead, and of course there's Gandolf.