For most small DIY jobs, I find an 18v combi drill ideal. Doorknobs, curtain rails, coat hangers, fence repairs.
Get one with two batteries. Not the big batteries because they are heavier and more expensive. The ones around £50 are not much good but worthwhile if you are hard up and have a particular job, such as building a shed or fence, in mind, because the job will be finished before the guarantee runs out, so you can take it back and get a new one if it breaks. Aldi and Lidl have a good guarantee. You can get a better one around £100 to £150.
If your wrists are weak, a 12v will be a bit lighter, but slower so probably no help. I don't think you will manage an SDS+ for concrete drilling.
A corded hammer drill will be better if you expect to drill into walls a lot, or lay floorboards, but is less convenient. More power for less money and weight.
Buy a set of about a dozen HSS twist drills and half a dozen masonry. You will only use two or three of them, and can buy replacements of your favourite sizes later. Some drills come with a rigid plastic case which is very handy and a starter set of drill bits.
"Brushless" motors are better but more expensive. I don't think I'd bother unless you are very flush. Nor a £200+ kit.