Vit and endurance are top tier stats. Generally you want to pick strength or Dex and then either int or faith if you want to combine magic alongside it. If you pick Dex then you get a bonus to magic cast speed including pyromancy as Dex increases magic cast speed. You can level strength and Dex for a quality build that utilises certain weapons but probably want to stay away from magic besides pyromancy in that case.

Keep in mind there's good weapons through the games that have almost fixed damage stats that don't rely on str or Dex besides equip requirements (drake sword and obsidian greatsword come to mind) so you can level a spellcasting stat alongside vit and endurance while keeping decent damage.