Buying a drill turned into a collection accidentally for me.
1.)I have a cheap own brand ("ROK") "beater" drill which gets all the dirty, rough, abuse jobs including running a drill operated water pump when working in holes in the garden.
2.) Then there's the reasonably cheap black and decker hammer drill I bought before I moved over which does 80% of indoor jobs
3.) Dewalt Drill/driver (DCD785), which mainly does jobs of convenience (space restrictions, when not near sockets, when the electricity is off etc.) but is capable of much more. I've used it for hammer work when fitting chor bolts for garden post lights, but the 1.5Ah batteries I have for it are the limiting factor.
4.) Bosch IXO driver for indoor/desk use.
5.) Titan SDS Plus for heavier work - as mentioned, it's rough around the edges but great value, and even did it's best when trying to drill through some granite rocks we have in the garden. For concrete work however, I would get a proper breaker. Before I bought the Titan I hired a Hilti breaker and the difference when breaking down concrete set gate posts was night and day.
6.) Dewalt DCF899 Impact Wrench - but now we're drifting into car territory...
I'm sure I could easily whittle that lot down to 2 or 3 drills, but they all get used.
If I were buying a first drill again and budget allowed, I would buy a Dewalt DCD795 and a 3Ah battery (or the Milwaukee/Makita/Bosch equivalent). Be warned that you are buying into a battery eco-system so i'd look at the respective ranges and see what you might need and how much the tools are.
An example is when I bought the DCF899 Impact Driver, most the competition were much more expensive (body only), so if you can imagine yourself expanding the range, bear it in mind.