Rotating a group individually in EAGLE
So, in the end, I fixed this by manually editing the part in a text editor. Removing all ROT=90 references for the pads removed any rotation transformations.

I modified the sequential-naming.ulp to work correctly with whilst in the library editor. I might take the time to extend this to work in other modes as the one included in my EAGLE installation only worked in schematics.