I can see the advantages using a high-powered battery drill from a flexibility view, I do have a basic dewalt - good for screwing but not enough power for drilling. I think getting an SDS type drill would be the best option for me providing it will allow me to drill small holes also?
To be honest - I think you'd be ok with a normal battery drill-driver. I use the battery drill for small stuff because the it doesn't need the SDS. My battery drill has done me proud for 3 years - wood, masonry and metal.
For screwing the battery wins - it's features of toque limiting, lighting the area, light enough for one handed operation and small enough for confined spaces win outright.
The SDS can screw but it's not featured it's a drill that has enough low down torque to screw at slow speed.. so it will apply full torque when the screw is fully sunk.. with head stripping/snapping the screw/burying the screw being the result. I would not use the SDS for screwing if I had a choice (tried and having a two handed drill leaves no hands to hold the screw then at the end it stripped the head in a blink of an eye at full speed
).
For drilling the battery drills aren't slouches - they will do the job. If it has a second attachable handle then it's even better (mine has, as do most).
The battery drill is beaten by the SDS in drilling and hammering performance. Yes. However the form factor of a small drill really is a benefit (having a hand free for example). With a DIY handy drill/driver.. a bit slower/less power is trade off against the flexibility of use will be a winning move..
The SDS chuck states don't use hammer action. So I use it for wood and metal rotary drilling only. The battery drill will do hammer quite nicely (the last few moments of the video show the battery hammering) and you will not have to be a gorilla to hold it. I've used the battery hammer to put the bolts-brick in my garage. The differences is the SDS litereally pokes straight through brick when I tried it - so I was scared to demo it on the floor lol (I figure that it's about 4 times+ the hammering force).
Battery drill + good bits will do. The Makita drill bits have done me for the 3 years for the flexibility. If I was to pick one of the drills - I love the SDS but the battery one has more flexibility..