I will second the Dewalt for general purpose home owner use. Makita for commercial use.

Old Frog put me into the Dewalt 18v drill when working on the boat.
I just bought an electric reciprocating saw and like the fire out if it.

For light duty occasional use, Black & Decker will do, but you might like the B & D but you will love your DeWalt.

DEWALT hands down the best. i use them everyday. milwaukee makes great corded tools but i have a set that was used less than a year and every battery went bad.

DEWALT hands down the best. i use them everyday. milwaukee makes great corded tools but i have a set that was used less than a year and every battery went bad.

for standard homeowner use get the portercable lithium ion, not expensive and the one I got was about 150 with 2 batteries and charger and an impact driver.
as far as attachments you will have to buy a multi tool package, again porter cable, sawzall, skill saw, drill, jigsaw, etc. can all use the same battery. I have never seen a drill attachment for anything.
been in construction for about 35 yrs and own 5 dewalt battery drills, one 6 pc kit, have used about every brand made and the porter cable 19.2 volt li is so far the best.