To me the ideal magic system has some direct way of interacting with the narrative and themes; it's something that is somehow meaningful (at least to the characters in the setting) beyond just its instrumental uses.