You've opened up a can of worms here!....this could go along the lines of a what tyres/oil is best thread!!!!
I work in construction and use Dewalt stuff...it gets a bad press, and it's normally the Black and Decker one that does most harm.
I think what is 'hot' or 'best' in the tools range rotates like a circle...at the beginning it was Matika, then Dewalt, then Matika again, Hitachi have had a stab, Bosch have always been around but never dominated, and now it seems to be Panasonic.
They are all competing and pushing the quality of the products up...but cost has now become a big issue.
I do think Dewalt products have suffered recently, and would agree I've used some Makita stuff that is better....but they are not s**te!
I use the 18v combi Dewalt drill and it takes some beating (..and it does take a beating!) for power...it's just a bit too heavy.
I'd be honest and say any drill would probably do you, even the ones in the 'budget' or 'home DIY use' ranges...(some of the Erbauer stuff is suprisingly good)
All you've got to look at for 'occasional use' is two things.....voltage and amp hours....and then also what you're prepared to spend!
An 18v drill will have more than enough power for all jobs, a Dewalt or Makita one especially....get a 14volt it will be adequate for most, but struggle with some jobs....a 12volt will again struggle with some jobs cos it won't have the torque...anything below 12volt is for 'screw-driver' applications IMHO
The amps relates to how long the batteries charge will last in use.....the cheaper one's tend to be low amps, so take more charging and won't have as much 'punch' in tough jobs...the more expensive ones will last a long time and have the strength.
I use my 18volt Dewalt nearly constantly all day, and it rarely needs more than one change per day.
So....I guess that hasn't helped you much!!
Me...I'd recommend you shop around....Screwfix..and B&Q are doing some amazing deals at the moment!
For some thing that will do anything you'll ever want of it do, then I'd go for an 18volt drill by any of the leading makes, Dewalt, Makita, Panasonic...they'll all do the business....it's then just the price and what deal you can get...looking at £200/240 for these.
...or a cheaper one, 18v Erbauer at £120!
I would buy a Dewalt Combi 18volt tomorrow if I needed a replacement without hesitation...if that helps???