Do you have a recommendation for a good dynamic lav mic that would be workable in this situation?Yeah, that's why I use XLR only, but then again I'm an old saxophone player. XLR is home base for me.
I think no one has made a plug-in power preamp is because by the time to spend the money on a preamp for it you would have been better of buying a proper XLR outfit. I think it's because plug-in power is sort of an amateur solution. For instance Beachtek makes an "adapter," but it costs more than my AudioTechnica 875R microphone and the audio is nowhere as good. Take a look at them anyways: https://beachtek.com/product-category/camera-adapters/
Honestly, I'd get a dynamic lav mic and call it a day.