The Lord of the Rings, Harry Potter, The Wizard of Oz, the stories of King Arthur - there are so many examples of great, epic stories with wizards at the center of them! I'd have to say Merlin, the wizard int he King Arthur legends would have to be the first that crossed my path. Merlin was thought to be born of a mortal woman, but his father was something spiritual, which provided him his magical abilities. Merlin was a shape-shifter and a prophet.
Wizards sure get our imagination going, and make for some really great stories!