Milwaukee impact drill M18 cblpd-422c 1x4.0 + 1x2.0 Ah incl. suitcase.
This drill is one of the most popular drills on the market.
With a length of 165 mm. this machine can handle most of your needs.
Don't worry about it running out of power, as 2 batteries + a charger are included.