Play thru Dark Souls. The first time play what ever you want to be, but collect every sorcery item you can find. Then play NG+ as a sorcerer and you will discover the true power of magic.
Same is true with DS2. But from what I can tell with DS3 magic is useless until you are really uber powerful. I never even tried a full magic build in DS3.