If you are cool with CRPGs may I suggest Arcanum? Probably has one of the most weirdly in depth magics systems.