So, it's not the cheapest solution, but, have you considered the Aputure MC? The back is magnetic, it has a 1/4"-20 Female thread on the bottom, charges wirelessly or over USB-C. Fully controllable as far as light temp and intensity are concerned. if you're on a show right now they might have some you could check out. I just got two in the mail today after being on a short with them for a few days. My plan is to mount one to the top of my cart with a Dinkum clamp and use the other to magnet to the underside of the deck of my cart to light cases, drawers, the surrounding floor.
https://www.adorama.com/apmrrgbl.html?gclid=Cj0KCQjw9_mDBhCGARIsAN3PaFP-tGRNeDe1X1AqNr3py_TtWbJVsIziTaqSD3dcFoXVqAKQrDA7GbEaAivmEALw_wcB&gclsrc=aw.ds&utm_source=nmpi-google-dsa