you’ll have to change a lot of things in your gear if you want to make another spec at that point, each spec has it’s own caps for hit , requirement if needed for crit , SP is viable for all of it of course but hit/crit and set effect differs . so give it a proper thought first and make sure you can cover it
Affli is actually quite good in single targets, as long as they have a huge HP like raid bosses. This is due to drain soul. I’m currently using affli pvp spec to leveling and it does alright with most pve content. Second spec I’m using Demon and it is obviously better for pve but not for much.