The music video databases have always been rubbish. I found only a small percentage of videos would scrape successfully. Then, to makes things worse, MTV withdrew their music video database so now the only scraper that works is Yahoo and that doesn't work very well.
To get the music videos into your database you'll need to write NFO files for them. See
http://wiki.xbmc.org/index.php?title=Imp..._nfo_Files for the details. It looks complicated, but it isn't really. Once you've got one NFO file working the rest will be a copy and paste followed by a couple of changes.
But, there is still one last problem. When MTV withdrew their database the XBMC MTV scraper was marked as broken and is probably disabled on your system. However due to an unintentional, erm, feature, if the MTV scraper is disabled the NFO files won't be processed so you need to reactive the MTV scraper. Assuming you use Windows (it should be obvious how to extend this to the other OSs) on your keyboard press Windows-R and in the Run dialog type:
"%appdata%\xbmc\userdata\Database"
(including the quotes) and click OK and an Explorer window should open. Delete the file Addons.db. Now start XBMC and after a few seconds you get a message "MTV scraper is broken, do you want to disable it". Answer "No" and this will leave the scraper enabled.
Leaving the MTV scraper enabled won't do any harm, it just won't do anything.
JR