Raiding is very accessible for you.
Hunter: From my understanding (I don’t play Hunter); https://wowlazymacros.com/forums/topic/bootys-8-0-x-bm-macro/ — is doing very well in both a raiding atmosphere as well as a casual PVP environment.
Priest Shadow: https://wowlazymacros.com/forums/topic/word-of-the-void/ — I personally use this to raid with in addition to running high m+ keys; 9/9 Heroic BOD, 2120 IO last season,
Priest Holy: I don’t heal, but I know that John makes very well-performing healing macros — https://wowlazymacros.com/forums/topic/hpriest-101/
I don’t play a mage, paladin, shaman, nor warlock, so I can’t recommend anything there.
I used to play druid but a lot of the druid macros are ‘ok’ for casual play, not very good for competitive play such as high key running or mythic raiding. Although Admiral makes good macros as well, you’d have to experiment with his boomie macro and see how it performs — https://wowlazymacros.com/forums/topic/disco-chicken-season-1-m-and-raid-build-by-admiral-smurf/
As for competitive PVP… you’re not going to find any macro that’s going to put you ahead of a casual player, imo. Many will do a good ‘casual’ job, but if you’re trying to push a 2K+ rating, you might struggle.