I have a Craftsman Corded Drill with a hammer function. Best investment ever. Someday, you will need to hang something into brick or cinderblock, anchor something to cement, or latch something to concrete. Nothing but a hammer drill and proper bits will do. My next drill will be an industrial-grade version, but so far this one has lasted 15 years of abuse without a hiccup. I love it.
As for cordless, I use pretty basic Black and Decker products with the 18v battery. I would recommend picking up an impact driver in addition to the drill. This has an impact function and is physically a bit smaller. It is nice for torquing long screws into decks, turning lag bolts into trees, and extracting really stuck screws from old barns. I liked my sister's Dewalt Combo Pack (pro contractor BTW, not a girly girl)
I think all of the brands at HD and Lowe's are probable pretty similar, so go with what's on sale and put the savings into REALLY GOOD drill bits. At the end of the day, the drill is just a fancy electric motor. It's the bit that does all of the work. Yes, that one bit for $12 will do a much better job than the same size bit from the set of 100 for $5 you got at Harbor Freight. And drill concrete with masonry bits, steel with bits rated for steel, etc.
