If you can convert the battery to a "dummy" with weight & connector on the base to a 12V SLA, things begin to look better. You need a cyclical vs standby duty battery, but 12V 7Ah can be had very cheaply
- or just a pile of D NiMH or similar. Removes the proprietary nature of the OEM battery, but cost saving isn't that huge.
There are 24V or 48V DC power tools made with external batteries, used in specific areas where 110V is not permitted. Might be equivalent of ATEX or similar approval re working in grain areas or such. Probably a silly price unless used, then again RS may do them in which case a silly price is guaranteed.
I am surprised we have not come up with 24V "corded or cordless". Just a central big pack you sit on the floor, so you get near the power of corded and get the convenience of cordless when needed. Then again, like inkjets the money is made on the batteries and not on the actual toolhead itself in many cases. Never investigated how easy (or not) it would be to change the 240V motor in a corded drill to a 24V motor. Truck battery might be a bit on the heavy side to carry around. Turning it on its head, a mains (or 110V) drill running via an invertor off batteries might be useful although expensive.
Cordless drills are so wimpy when you occasionally pick up that long forgotten worn out cheap corded.