I have used a number of lights, including most of the above.
DRIS 1000 lumen original. Takes 3 C cells, or 3 AA in holders. This has been my back up light for probably 4 years with no problems. Twist on/off.
DGX 600. Same brightness as above. My primary hand light for a couple of years until recently. Nice size, uses 1 x 18650 and a twist on/off switch. It has seeped twice over the space of about 10 dives. This caused the Li-Ion to outgas and made opening difficult and left a mess inside. Both times I have been able to save the LED and electronics, but I don't trust it underwater anymore.
I have had issues with magnetic switches before, but the latest issues had to do with alignment after converting the reflector to wide and diffuse for videography. I am no longer doing that.
I have tried 2 new lights on my last dive. Both worked well, but I only have one dive with them yet. Both have slide magnetic switches. One with variable intensity, 2 x 26650 5200 (true) mAh cells and a little brighter than the above lights. This is a BrightNights 1000 lumen light. The seller has been eager for my feedback and seems interested in producing a good light. I'm discussing a shorter version for hand mounting. The other new light is a Brinyte DIV 12 light. Slide magnetic switch with 3 distinct modes. A single 18650 battery, and not quite as bright as the BrightNight.
For video I use 4 Archon D11V lights for my video rig.
None of my lights cost more than $90, and most around the $50 range.
Highly recommend you get something with at least 500 true lumens.