"Memory effect" in NiCd's was discovered by partially discharging and recharging multiple times (e.g., in satellites). Do not trickle/float charge. When they were used in model airplanes (e.g., weekly), I charged the night before I went flying. We also charged after a flight.
Welcome to battery-power. They have some conveniences and some serious inconveniences. My 3/8" Milwaukee electric drill (circa 1980) is still running strong on its original power source. Can any owner of a battery powered drill say the same?
I agree that mains power is better in many ways. Batteries have never worked well for me. In laptops I could never get anywhere close to the run time they advertised. And batteries are expensive.
Yes, I have drills that are very old and still work fine. Mains powered drills can last forever if not abused. Most of the ones that fail are because they were driven too hard. You cannot abuse them and expect them to survive.
But battery powered drills/screwdrivers are a different tool. They turn slower and more controllable. If I want to drill a hole in the brick or concrete wall I use a mains powered, powerful hammer drill. But that tool is not good for driving screws or slow drilling in metal; for this I prefer a battery type.
But I do have a couple of the battery ones which I can connect to external DC power. If I am assembling something big in the garage and moving around a lot then battery is good, but if I am working on the workbench without moving around too much, then I can use a DC PSU to supply the drill and the cable is not really in the way. In my experience these drills have high tolerance for voltage and I have supplied them from different contraptions and they always work well. They do not require stable voltage at all.
When I am working on some project it is convenient to have several drills, one with a drill bit, another with a screwdriver, etc. and it frustrates me to always find this particular one is flat. It is like I don't have it.