"Decrease throttle/power and the blade angle is reduced. Increase power and the blade pitch angle is increased. As long as the governor isn't at limit, the RPM will be constant (within governor tolerance)."
RIGHT, NOW CHANGE THE PROP SETTING WHEN THE THROTTLE IS UNCHANGED...WHAT HAPPENS THEN?
It depends

The reason for a constant speed propeller is to maximize the efficiency of the propeller over a wide range of speeds.
The faster you fly, the coarser you're propeller blades pitch will need to be to maintain it's most efficient AoA.
You will need to analyze each engine / propeller combination to determine which setting is best for each engine / propeller combination.
Changing the RPM with the CSU control may increase, or it may not.
HTH a little bit and doesn't cloud things further.
Cheers,
Rod