One thing I don’t really ever coming across in the harry potter books were people being exhausted by powerful spells, perhaps I just can’t remember a case where that happens.

It’s always portrayed that you need a base magical ability and then from then all it’s all knowhow.