[Potential spoilers] Pondering which "class" of spells to go with

Hey guys, so I've just finished my first play through with my chosen melee style, and I'm not interested in starting a playthrough with a caster, purely (trying to at least) using spells. Thing is, despite now having completed DS1, 2 & 3 I have pretty much never used spells, outside of Soul Arrow and early variants in DS2, which I didn't enjoy too much (those specific spells just didnt "tick" with me). I'm now wondering which type to go with in terms of pyromancy, sorcery, miracles or hexes... I'd appreciate a basic rundown of what I could expect with each line, I'd be looking for the most effective whilst being diverse whilst having an interesting progression path (want that "woot" feeling when you get a spell later in the game) currently I'm thinking pyromancer, but does it become a bit one-trick pony and also predictable in PvP? I don't PvP much at all, but it's still something I enjoy. Anyway rambled on a bit here, would appreciate any advice!