I could not find a good mic with audio input. As you say, they all wanted power and a preamp. I ended up getting a unidirectional (cardiod) capacitor microphone with a USB interface:

https://www.amazon.com/gp/product/B07YJGSHJS

I'm pretty happy with it.