I think for Homebrew setups it doesn't matter as you're getting more than enough due to the natural splashing into your fermenter...the ratio of the surface area exposed to air as its transferred compared to the total volume of wort will be quite high. In larger brewhouses where hard pipes are used and wort pumped into a very large fermenter f probably doesn't see any air or much agitation in the fermenter, and any agitation wont stir up the whole volume of the wort so only a small proportion of the wort will actually see any air, hence the need to oxygenate in-line during transfer.
I usually splash it around a bit, but don't pay too much attention to it these days and not suffered any negative impacts during fermentation. Certainly don't think using a drill and paddle is necessary, though wont do any harm, and I think what you need is a turbulent action rather than a smooth laminar flow vortex which you'd get with a drill and rattle....I suspect you'd be better off using the paddle manually in a back and forth motion to splash the wort around.