Actually amsn for Maemo 5 does do webcam and will work with msn clients using a computer, so far as I know it's the only tested working app for the N900 with webcam support. And I totally agree, Skype vid would be great if someone's willing to make it happen.

amsn: http://www.amsn-project.net/maemo-downloads.php