Hi
There is no camera that works with msn. unfortunately msn does not support video on mac. you can use your mac with skype and ichat for free. you can get a good quality camera from the fallowing link.
http://www.i-lovemac.co.uk/products.html
it does work with any mac including apple laptop
I hope this will help