I feel you. For what it’s worth, I will prefix my macros with an identifier to help sort by class. For example, all my druid macros start with dru. and all my paladin specific macros start with pal. I find that really helps, but I realize that if you play multiples of a lot of classes it could still be challenging.
There could definitely be some UI refinement on the macro screen. If nothing else, being able to check which class(es) the macro targets and then having a filter button to show only specific classes would help a lot.
Now that I’m thinking about it, I bet you could find an addon to help with this. Does anybody use anything like this?