The stuff which most of the pros use is meguires master glaze stuff which comes in brown bottles and looks really boring. I used the 105 cutting compound and 205 polish and it left nearly a perfect finish with the rotary. The only bits it left were stuff which I personally did not feel i could get out without getting very serious with, but did not want to go there for fear of burn through.
I have tried the speed glaze which works really well but I only applied that by hand and have yet to try it on the rotary to see the difference.
I have hear various reports about megs waxes in the fact that they dont last very long but do look good, but i havent tried them.