Yeah to get swirls (spider webbed look) you will need a good compound and a DA.
Even though it's not a super polisher/buffer, my Porter Cable 7336SP does a great job. You can, but I don't waste my money on all of the different pads you can get. It comes with a good quality foam one. I just bought two more of those. So now I have 1 for compound, 1 for cleaner wax (or whatever), then the last for sealant/wax like Griots Best of Show. However the best way to prep your paint is to CLAY it! Smooth surface to start with, even with clear coat defects, is a MUST to getting slick as glass paint.
But that's just my method and it has always yielded excellent results for me.
Like this.....sorry for truck whoring.