There are two stickies over in the Test Equipment forum. One talks about a LOT of meters from a LOT of companies and the other gets into whether they meet their labelled safety standard.
In my view, the DMM is the absolute worst possible tool for mains work. I will always trust the NCV that I tested on a known live outlet before and after I verified that the outlet I am working on is deenergized. But the key is to test on a known live outlet before and after the real test. Particularly if the unit has an on-off capability. I have a couple of NCV plus at least 2 DMMs with the feature so I do use them from time to time.
I spent my entire career using a solenoid style tester. I can feel the tester jump in my hand (especially on 480V 3 Phase) in addition to the indication on the scale. I did electrical work at one level or another, not much electronics.
https://electricalparts.com/products/knopp-14460 I haven't chased down lower priced units because absolutely nobody that isn't in the trade will use such a tester.
Again, the requirement is to test the tester before and after testing the circuit being worked on.
And then there is the Lock Out - Tag Out process. Maybe not a big deal on residential work because you pretty much control the environment (if you are working alone) but a huge deal in industry. At my advanced age, I'm not sure I would trust a working partner even for residential work. Locks are cheap...
Why I dislike DMMs for mains work: I want my eyes focused on where my hands and the probes are going. There may not even be a way to mount the DMM if the outlet box isn't metal and the meter outfitted with a magnetic strap. So, it's dangling from the probe leads and may not even be readable. In general, I am testing for presence, not the absolute value. I don't usually even care about the reading.
The NCV tester may not be loud enough for the environment. Aircraft plants get a bit noisy. They're probably ok for residential and I use one all the time but it seems questionable for a tester to have an on-off switch or pushbutton. Pre and post testing is absolutely required less the thing turn off half way through the procedures.
The solenoid tester jumps and buzzes and one probe is mounted to the body during use. I can see where I'm probing and I can feel the result. Often, there will be a little spark at the probe tips and that's kind of a clue. I don't have to look at the scale but, if I do, it's right in my hand - where my eyes can keep track of things. And no on-off switch!
Just my opinion, others will vary. And most people will use a DMM anyway. Some have NCV capabilities and that's way better than just an LCD display.