I very much like the system from the Expanded Psionic Handbook. I think it's by far the best magic system for D&D, and d20 games in general.