I have been happy with the super hawg with the adjustable chuck. I also have one of the M28 right-angle drills with the drive extension. The 32" extension goes between the motor and the chuck with a 45-degree bend at the end. You can drill through ceiling joists from the floor or a very short ladder. You can also drill low or high on wall studs without having to bend down or step up on a ladder. It makes me way more efficient during rough-ins.

I have also invested in the Milwaukee 5PC SwitchBlade™ Selfeed Bit Plumber's Kit. Never a dull bit, just swap out the blade and you are good to go.