I never liked dry sanding with a rotary either. I always wet sand if using a drill or by hand. For hand sanding, I really like the Meg Unigrit paper. I get the 5"x9" packs at a local auto parts store.
I use a basic 5" variable speed palm sander... bosch, dewalt, pc, etc. It can be tricky to...