you need to be greatly commended for the amount of work that you have done on your own to:
research and then try to resolve this issue:
from this website
http://mxhaard.free.fr/spca5xx.html
MicroSoft 229 0x045e 0x00F5 VX3000 sn9c105r OV7660 Yes Jpeg gspcav1 ***
your camera is gspca .. and the drivers were put into the 2.6.27 kernel .. and it .. should work ...but does not
______________
you ask what cameras do work?
Well, it is said that UVC cameras do; (out of the box ..)
and this website
Linux UVC driver & tools
lists them .........
but buyer beware ...........
.. some say webcams are cheap so just buy a new one, and .. hopefully ......... a UVC compliant webcam will work