Bought one for like 20$ from HF to see if it was something I would invest in further, turns out that one was pretty damn good and didn’t need to. They seem to be more for the machine shop setting where you’re always in one place and need to drill a lot of holes at a time, that’s where the advantages outweigh needing an air hose and compressor attached to it
they’re much smaller, usually more powerful, stop as soon as you let go of the trigger and have near infinite runtime (actually gets cold instead of hot which is nice) as a result of no electric motor to burn out/overheat or batteries to die. Also like most air tools they last forever and are never obsolete. Only other cons than the obvious are they can be pretty loud and sometimes spray an oil mist