For that kind of usage and application a hand held light is going to be totally useless. Unless you can change your car tire, or do general house-repairs with one hand.
Go with a headlamp first, and supplement it with a hand held of your choice. I personally am partial to thrunite and zebralight designs, but there are MANY to chose from. Both have served me very well around the house and on dozens of camp-outs and backpacking trips as my sons boy scout troop coordinator. The Zebralight is almost 10 years old, and pictured with its clip-on mount.
Oh… Don’t knock the harbor freight freebie!! Seriously my son and I have used the blue light shown below on half a dozen camp outs. I have one and so does my son for his load-out. Its been every bit as useful as any high $$$ lantern, and a fraction of the size and weight. Its not water resistant, but I bag it in a small zip lock freezer bag, with a small hole in the corner to run the hook through. In all honesty its been GREAT, and of course you can’t complain about the price. Several of our scouts use them as well and we have not had a single incident of failure. Its resistor direct drive, so just load up some duracell AAA and run them till they die. We use the magnet and stick it onto whatever metal we can find. The back of a Coleman camp stove wind screen works best. The button is firm/hard enough to press and it alleviates accidental turn-on.