For a good acoustic sound, the best microphone I’ve ever come across is the DPA 4099. It’s not cheap but worth every cent as it picks up the rich sound really well and is relatively adverse for feedback.
Currently I’m also exploring with microphones inside of the flute. Its very tricky but this year I’m collaborating with a team of students from the HKU Media and Technology department to work on this.
