We've tried all types at work (I.e. Makita, Dewalt, Ryobi, Porter Cable, Milwaukee...) and they all work pretty good relative to what you pay.
We started using Festool battery drills for applications where a standard drill won't work. They are very expensive, but very well made. Unfortunately...