Rode mics are considered the best. I use Yoga myself.
But why do you want to camera mount? Is it for show? (in which case any old mic will do)
The microphone needs to be near the source of the sound. A camera mounted mic will pick up the same sound as the internal mics so is of little benefit.
Get the mic as near to the sound as possible, using an extension lead if needed. Example, a concert, If you are videoing from the rear of a hall with a camera mounted mic, you will pick up all the audience noise before the music, so coughing and muttering will become part of your soundtrack. The mic needs to be in front of the players.
The only advantage of a camera mounted mic is that you can easily fit the mic with a wind shield (deadcat). Essential for most outdoors recording, available from the mic makers (at a vast cost) or Amazon. I made my own and it works for my Yoga mic and my Zoom H2.
Just looking for the best external mic for a Sony HDR-CX260V? Would like to have one that mounted on the top. Thanks for any help ahead of time.