I think the closest I've seen to real flexibility with magic was in Morrowind, where you could make your own spells. It didn't drastically alter the game, but it let you tailor magic to your gameplay style. But I would LOVE to see a more inventive D&D approach to magic some day.