What do u want to drill first and foremost coz the drillz u buy need to be suitable for the material

wood no need expensive tool.. any made in china drill also can handle wood easily.. drilling holes in wood is easy.. screwing into wood AFTER predrilling a small hole 1-1.5mm also doable.. screwing directly (no predrill) into balau or other super hard hardwood is another story

but walls.. this is where it gets interesting.
concrete walls, no cheap way, use rotary hammer else u will spend 5-10 min per wall plug hole.

brick walls (orange clay brick/sand brick), cordless one for 200 bucks tool-only will work (with hammer mode)..you're looking at the bosch GSB180Li and similar.

Those are two different power tools for different working purpose.

Battery hand drill (cordless) - mainly function as a replacement for manual screw driver, drill holes on wood/timber, assemble ikea simple furniture. Pick any 12V or 18V model should be sufficient. No need to go for high power model because those models usually are more heavy/bulky.

Rotary hammer (corded) - mainly for drilling holes in concrete/ brickwalls/tiles. Heavy duty works like drilling hole for mounting mirror, cabinets, towel hanger, those kind of stuff. You can't really use it to assemble Ikea furniture as its too bulky. For rotary hammer, it's better to check out branded one like Bosch, Makita, etc. https://www.cthardware.com/ is a good place to explore.

There is cordless rotary hammer but totally unnecessary for home use. It costs upwards of thousand ringgit easily.

2 cheap tools that do one correct job is better than 1 expensive tool that do half of the job.

If you insist on one tool, impact driver can do a little bit of both.. but it could be too strong that destroy you ikea furniture and at the same time not strong enough to drill fast in concrete. And branded impact driver is very very much expensive. Plus, you need to buy quite a few different accessories to work.