So this is my little setup at the moment. I use my google pixel 2 with the 100mm apexel lens on a stabilised gimble with a clip on ring light, the Panasonic lumix fz100 which I always thought was a dslr turns out isn't
its a bridge camera 
Though I'm currently looking at getting a telephoto conversion lens for this with a macro lens which if my research is correct I should be able to then take macros from a tripod with it, though if any experts want to correct me or even better give me a cheaper option that would be great 
All in I think the gimble, macro lens and light cost me around £75
Some more macros
Discord
Links