What are the best cameras for music videos?

Time is the best camera for most things.

The more time, thought and effort that you can put into a music video the better it will be. Any camera you use will be good for a music video. Music videos pioneered the use of shooting with a whole bunch of different cameras, looks, textures and styles all in the same video.

First a bit of history. The original music videos were shot on stage live. Just the band playing. Then matched multiple cameras were used on stage live. Then additional outside the stage images were blended in. Then music videos were shot lip sync in various places. Then over time more and more elements were added into the mix.

My advice, gather together as many things with lenses and use them all to shoot the music video. Each camera has a different look and texture this difference is a big visual freebee. Getting a DSLR with it's shallow depth of field into the mix is good. Lots of variety is awesome. The second a music video seems to lose it's surprises is the moment when the viewer switches away from it. Keeping things visually fresh every 3 seconds is a huge challenge.

Course it all depends on the content of the video. If the planned video was designed to look like a mini movie then you would need a conventional cine camera. (RED, DSLR etc)

But again the anount of time you can spend planning shooting and editing will by far have a greater impact on how the music video looks than a camera hardware choice.