NiCd & L-Ion are good for DIY - they hold a good charge for several weeks. NiMH is good for trade - leave them any length of time and they will be flat.
Suggestion-1 Screwfix still do a Dewalt 18V with twin batteries for =A3100. It has a
13mm chuck, good high rpm (1900rpm, better than 1300rpm anyway with many bits), decent power.
Suggestion-2 Ebay often carry factory-refurb Makita 12V drill/driver with 2-3x
1.3Ah batteries for about =A350 on auction. When the batteries get tired buy a generic 2.0Ah to replace each.
The problem with cheap "DIY-targetted" cordless tools is the batteries are 1.3Ah or 1.5Ah, which seem to have quite a steep discharge after a while such that you want a fresh battery before it has fully discharged. Not like the older 1990s batteries which seem better.
A generic 2.0Ah battery can be really good in that respect, it just keeps on going. The 3.0Ah NiMH with a =A3130 tool are very good because they really DO keep on going - but self-discharge.
Forget a combi, they tend to be heavier for little gain.
6-8-10mm holes? Cordless drill/driver with Bosch Multi-Bits (no hammer, just drill away).
Numerous 6-8-10-24mm holes? SDS, however for most DIYers the above bits render SDS unnecessary.
22-152mm holes? Diamond core drill such as Sparky (=A3130) Makita (=A385 used to =A3230 new).
A good SDS can of course do a good job as a diamond core drill - needs a good clutch, high wattage, lots of torque. SDS need to step up to the plate against the Bosch Multi-Bits and become a better diamond core drill - most are good, but they need the low-speed torque (how about a proper 2-speed gearbox?).
If you google and do want a twin 2.6Ah NiMH you can probably find a Makita for about =A3109-129, they crop up every now and then. Very good, very powerful, think they may even have 13mm chucks - small are a PITA.