I have Nokia 3230 and have experimented lot of software on it. Mobiola application is the application to use your mobile phone camera as webcam. Visit mobilesmania.com and search and download the full version of this applicaiton.
RIM Blackberry Any Blackberry devices equipped with camera
Windows Mobile Windows Mobile 5 and 6 devices equipped with camera
Nokia 6600, 6620, 7610, 6630, 6670, 6260,6680, 6681, 6682, 3230, N70,
N90, 3250, 5500, E50, E51, E65, E70, E90, N71, N73, N76, N80, N81, N82, N91,
N92, N93, N93i, N95, N96
Sony-Ericsson P1i, P990, M600, W950, W960, P800, P900, P910, P990, G700, G900
Motorola Z8, Z10