If you want it for a variety of tasks, drilling into brick, metal, wood etc then I’d go for a Combi drill of some kind.
Mine is a Dewalt DC795
https://www.howetools.co.uk/dewalt-dcd795m1-18v-combi-drill-13mm-keyless-chuck?utm_source=google_shopping&gclid=CIa13Nj4iMoCFYOfGwodvJ8J5w
and gets daily use in the construction industry but Makita, Bosch professional, Hitachi etc. will all have something available probably as good. Avoid the green Bosch models and the cheapest Dewalt drills as they have a plastic chuck, they’ll work just not as long.
I’d look for a deal with a couple of 1.5ah batteries if poss as one can be charging whilst the other in use also they’re lighter to handle, having said that the link I’ve shown has a 4.0ah battery which will keep going a long time whilst being heavier to use.
My 795 will drill holes using a masonry bit in all but the toughest concrete up to 10mm, has a 3 speed gear box for extra torque and a clutch for screw driving (all though I never use it for this) With HSS drill bits will drill up to 13mm holes in metal.