I have an old black and decker metal bodied drill my Dad bought in about 1970 and it still works. I would not use it today however, but I could if I wanted as the power source is still 240v, they have not changed that in all these years.
But I also have a bunch of old cordless drills tucked away under one of the benches in the workshop that would work if the batteries were still any good. Mostly Ni Cad, some NMH.
I am now buying lithium tools but buy expecting to right it off in 2-3 years. If it lasts longer than that great, but by then other lighter, smaller, more powerful models will be available, plus my batteries will be knackered.
So buy what you can afford, and buy the correct rated tool for the job so you intend to do so you do not overwork it and burn it out too quick like some people keep doing. Nearly 40 years in the trade, never burnt a drill out. They have fallen apart, gearboxes failed, switches packed up etc, but not burnt out.