Not sure whether to include T.H. White’s Merlin. He’s not exactly crazy, after all.

5. Fizban the Fabulous (Margaret Weis and Tracy Hickman) (except he was kind of faking)
4. Master Elodin (Patrick Rothfuss)
3. Arisilde Damal (Martha Wells)
2. Adept Havelock (Stephen R. Donaldson)
1. Antryg Windrose (Barbara Hambly)

Anybody else I should have on here?

Edited to add: I forgot Vic! Put in another entry on this list:

6. Vincianus Polymage (Greg Costikyan)

…from the unfinished “Cups & Sorcery” trilogy.