Never looked back since buying my De Walt DW160 dumpy drill about 4
years ago.

Basically it is a cylinder c. 90mm dia with a sideways on chuck. Back
side of drill to tip of closed chuck is around 110mm. It has solved an
enormous no awkward drilling problems & not just between joists. Where
necessary I use cut down spade bits - so you can drill a 1 in hole in
joist gaps of only 150-170mm.

No more angled/fiddled holes.

Main snag is that it is only c. 300W & mono-speed, so it is not a
replacement for a regular power drill. Also you have to be careful to
switch off at plug when leaving it as the switch is on the side of the
body & can turn on by the drill's own weight or an accidental knock.

Mine came from the late lamented BMJ Power (ex B&D service centre),
but B&Q were selling it as well. Paid around gbp130 - bit pricey but
for shear convenience, unbeatable.