Hey so after some more experimentation that issue is probably hardware, I am not gonna lie, ever since I got this stick (new) it has always been finicky. For example back in the day when I got it I could never get it to install the drivers on AMD based chipsets, no issues with Intel chipset though.
The issue I am seeing is that when I change the axis in CCP to the guide settings (or any other change I make) and select "User Mode" the axis are indeed changed although sometimes the stick becomes unresponsive and I have to reconnect the stick. When it works though and I go to the "Viewer" in CCP I can see the axis switch but the stick behaves really strangely. I guess the best way to describe it is that it loses resolution, with only moving the axis to there maximum will actually register from what I can see in the Viewer. The same happens if I run your script with Target and check the axis through there. (same behavior in game)
Have you ever heard of an issue like this? I also tried saving the axis to a profile and make CCP change the settings at startup but the same weird behavior happens.
When I said your script never worked with microstick is simply because the stick wasn't in User Mode in CCP, and if I do apply the changes and run User Mode the above behavior happens.
Anyways, I am back using Foxy with the axis at defaults so I don't run into the strange issue. I can set the microstick for mouse or key emulation no problems.
Back to the Foxy manual it is.