Just thought I'd share my thoughts on this. Having taken some advice from group readers I decided on a Linksys WVC54g.
It comes with a "desktop" type stand and the camera itself also tilts up and down and can be turned left/right and has a manual focusing ring. Performance is quite excellent in daytime and streaming the image across the internet was no problem either, although I do have a 448k upload speed on my broadband line, maybe it might not work so well on a 256k upload. I set mine to max quality and 640x480 which is the cameras max resolution.
In low light it fares less well obviously, but I will be using a very low-power night light in the babys room and an old laptop in the living room.
The motion detection built in to the camera seems to work OK, although it takes a good deal of experimenting with the settings to make sure you don't end up with 177 video clips in your email inbox as I did once!
Anyone else thinking of going for it, I'd be pleased to answer any questions.