I have the NiMH version of this Drill, and it is a great drill. Unfortunately, the NiCd version is not so wonderful. It has less power than the NiMH version, and does not last nearly as long.
Subjective question based on what you’re doing and how much torque/speed is required.
Personally if I need to be drilling stuff for hours on end I tend to use a lot of lube and… A drill press if ya know what I mean.
On a more serious note. It’s 18v NiCad, so its gonna be decently heavy to lug around, and will have way more torque available than the average home user will need.
If length of use is truly your concern either buy a couple of spare batteries, or get yourself a backup drill that has a cord.
NiCads will deliver more current under heavy load, which should translate to more torque. NiCads also have a higher self-discharge rate so they will go dead if you don’t use the drill for a while. They also have a “memory effect” and you should discharge them pretty much totally before you recharge or you will shorten their life. NiMH have a higher energy capacity, so they will last longer and not discharge themselves as fast, but they’re not as powerful.
I have a twenty year old Makita with the two original NiCad packs and while the batteries are finally just about at the end of their lives, it is still going. It’s been a great drill and has seen some heavy use.