Interestingly I have a first generation Bosch Uneo (green consumer device, non changeable battery). Uneo is a consumer level cordless screwdriver and pneumatic hammer drill hybrid, it will easily put up to four to six holes into concrete walls (enough for home use when hanging something, but afterwards it’s empty and needs to be recharged)
The Uneo is one of my most useful tools for occasional use, and I know of no other brand which offers a similar tool which fulfills those roles in a non-craftsman home.
If you regularly build stuff its battery is too weak, but I use it a few times a year. Hang a picture, lamp or a wall cupboard in my apartment (which partly has concrete walls in this high-rise building) - not a problem.