As far as drilling cement, masonry, concrete block, etc.......you need a rotohammer. A hammer drill (screamer) is only good for small holes, and is very highspeed, almost to fast to allow the hammer to work good.
I have Makita, bosch, hilti, and Milwaukee roto hammers of all sizes. Makita makes a great small rotohammer (up to 7/8") SDS. The makitas are affordable and have given me great service. I also have a bosch and a hilti in the bigger sizes (SDS+) they are animals. The bosch will walk a 2.5" bit right through a concrete foundation.
Get a good rotohammer....and stay away from dewalt. I don"t like their power tools either.