"I've also tried to lay down a bead of the product and go along with the buffer to pick it up, but I still have lots of splatter. I think I just need practice. How much should I tilt the pad when I pick up the polish? "
With very little pressure on the pad, tilt it so you pick up the polish at about 11 o'clock. Once the pad is prepped, which should be after a panel or two, you generally don't need much polish to continue.
With a rotary you should have little problems removing swirls. Chances are that the paint is not soft, as i have only encountered this once, on a new Honda.
I'm thinking that you might be a little timid with the rotary and are not letting the weight of the machine do the work. Pressure is everything, too much and you will burn through the paint and no pressure will do little. When you finish a pass, put your hand on the last spot, is it cold, warm or hot. Depending on pad and polish , heat will vary, but there should be heat. When i remove sand marks- hot, compound-warm hot, smr-warm. THESE TEMP RATINGS are by my hand and HOT, DOES NOT MEAN TOO HOT TO TOUCH.
"some say spritzing water or qd on the pad before buffing is bad and some say its good so what is it?"
Some people prep their pad (once)with a spray first, so they are not polishing dry to start. Some do, some don't. It has been stated that a water spritz (when needed) will add a little cutting action, as it probably delays the compound from breaking down.