Caimie is a legend, her guide saves sanity.
There is only one reason why a macro might fail if your stats get too good... if it was badly written. Sadly lots of them are.
Sure, muscle memory and then ground is a lovely opener, but you need to remember to use the final apprasial, that keeps it from capping. That's 3 lines used, and a lot of macros won't use that extra line. They'll just say it stops working at a certain point.
I remember the steps in crafting.
First you know nothing.
Then you follow somebody else's directions.
Then you read a guide, and start to understand.
Then you star making your own macros.
Then you go BACK to the guide to figure out what you did wrong.
Repeat until you actually know things.
... then you just look up somebody else's macro and use that.