for small jobs, IMO an 18v combi drill (cordless) will do most you want. It will drill brick walls, wooden floors, doors and frames, kitchen cabinets and fences.
It would be underpowered for concrete or large holes through fenceposts.
There are several available, preferably with a spare battery. low-cost tools usually come with a 2-year guarantee; and if this is from a reputable local supplier (so no postage costs for a return), you are pretty sure to get your money's worth. The spare battery means you can be charging one while using the other, so no need to stop for an hour's biscuit break.
IMO 18v is the ideal for small domestic jobs, not being too heavy to hold up a ladder, and not too weak to drill a row of holes, and will also drive screws.
Some come with a basic kit of drills and scredriver bits. however you can but sets ay modest price if not. Most likely you will only ever use two or three sizes of drill (3mm for pilot holes in wood, and 8mm masonry for brown plasplugs), and only the PZ2 scrwdriver, so don't overspend. When you have found which sizes you mostly use, you can buy half a dozen on those sizes only on fleabay.
A carry case is more useful as you will have the drill, two batteries, charger, side-handle to lug around.
Here are a couple of examples. Parkside tools at Lidl are also supposed to be quite good value, they are made by a German company and you can actrually buy spares for them (it is easier if you understand some German and are in the EU, or a country with a comprehensive free trade agreement). Einhell, I think.
example 1
example 2
If you are prosperous you can spend several times as much from a quality maker like Makita or Dewalt.
Don't get a drill-driver, which is too weak.
I don't believe you have any need yet for an SDS+
Don't forget ear defenders and dust masks.