Kind of drill depends on what kind of materials you'll be dealing with. Or the kind of DIY.
Brand etc depends on the money you want to invest. Each brand makes several kinds of drills.
- Precise and minute drilling - rotary tool - jewelry, case modding, polishing, small scale work.
- Precise but bigger holes - rotary drill - wood/sheet material, stainless steel sheets, ceramic tiles etc, polishing, sanding, work inside small spaces - cabinets/drawers etc.
- Precise holes but in hard material - percussion drill - hardwood, small holes in brick walls for hanging picture frames etc- lightduty work.
- Heavyduty work - hammer drill - not precise. Deep holes in walls for hanging TVs, Geysers etc., Huge holes in walls for exhaust fans/conduits etc. Any kind of demolition work on concrete, tiles etc. Uses SDS bits, which are wobbly and therefore can't be used for precise work.
- Huge but precise holes - diamond core drill - for making neat holes in walls for conduits, exhaust fans etc.
- Heavyduty screwdriving - Drill-Driver - for driving screws in logwood, removing wheel lugs etc
- Lightduty Screwdriving - any battery operated drill with clutch - Clutch prevents bit slippage and screw-head shearing.
If you just buy any drill based on money or brand preference, you'll be disappointed later on. Buy according to your needs. Some drills can be shared between different types of tasks with attachments but then it limits their capacity.
Reputed manufacturers make drills for regular and professional use. Obviously the latter ones are costly. So look into that aspect as well. Bosch blue is pro and costlier than its cousin Skil. Makita has blue range for pro use and red for regular. B&D is for home/regular use and often comes with a kit. In general, all the regular/home/DIY use stuff comes with some kind of ready-to-use kits. You'll have to buy attachments/accessories etc separately for tools meant for professional use.
