Funny enough, I was just thinking earlier today that the Eye of Magnus could play a significant role in TES VI. However, I doubt the current writers at Bethesda are clever enough to weave it into the storyline.
Plus, the Psijic Order disappeared with the Eye at the end of the College of Winterhold quest, so I don't see how that could work. Unless they do some time-traveling nonsense.