I have Weefine 2300 and can recommend it, I like it a lot:
#1.: The red LEDs opened a new world to me, as the red light does not chase (most) critters away (although AF with the more intense white light is more effective).
#2.: The 2300 lumen are plenty of light for complete nightdives (I switch immediately to red, when I see an animal of interests and continue photography with red light; feels like working in the darkroom
). Basketstars completely unfolded and endless time to frame shrimps, patiently posing outside their crevices...
#3.: More than enough light for macro video. The lamp provides enough light, even for occasional WA video. As you say, however, dedicated video light is the way to go in case you want to make serious WA video (we are talking here about a focus-light).
#4.: The blue LEDs are nice to have in nightdives. No nightdive since I have the lamp, where I do not switch on the blue light occasionaly - it is fascinating to see the fluorescence, even without any yellow filters. At a pinch one can even make occasional fluorescence photos (For serious photos you need, of course, special equipment).
There is now the Weefine 3000 Smartfocus lamp available. In case it is as small as the 2300, I would go for this one instead. To my opinion the 6000 is too big for just a focus light, even for a simple night dive lamp. Whether two of them are good and strong enough for WA video, I cannot say, maybe someone else has practical experience.
Wolfgang