My drill is cheapie Ryobi from a big-box home improvement store, but just about every other power tool I own is either a Black & Decker or a DeWalt (which, as you probably know, is just a somewhat higher-end Black & Decker). I know they're not the greatest tools, but for my relatively limited use, they're fine and are relatively affordable.
I have several friends who swear by Makita (and in the case of Sawzalls, Milwaukee) but I've personally found them to be overkill (and hence overpriced) for my limited use.
My only suggestion is this: no matter what brand you buy, make sure you get one with a good chuck key. 99% of the frustration I've experienced with drills revolves around the freakin' chuck key. Ugh.