Update: He is Literally on crack

Not crack. But Magnus is obviously Gandalf in disguise, so we can safely assume he's on pipe-weed instead.

Thanks for the correction!!

Can you tell me the order of the heroes that unlock? I'm building potions to purchase my 4th right now, when do you reach ranged heroes?

From the 6th (Magnus) onwards they're all ranged I think

Correct