Low light photography is my favorite style and the fact that I obviously cannot use a tripod and the smaller sensor makes it a struggle
If you're not trying to stay under 250g (which in the US is relatively meaningless other than a $5 registration), you can try adding a bit more weight to make it stable. I've found I can reliably get half second exposures in all but the windiest conditions on the Mini 3. My older Mavic Air which was twice the weight could go a bit longer, but of course the sensor wasn't nearly as good so the photos weren't any better in low light.
The other thing you can do is stack exposures. Unfortunately in low light the drone isn't very good at keeping pointed in the same place over time (since it generally uses the camera for that during the day), but you can probably at least get 10-30 seconds worth of half second exposures to align and average. That's definitely on my list to push the limits of, but I haven't gotten around to it yet.