I have used one from Crenova, 5 m in lenght,with usb 2, bought used, with the tip of the camera 8.5 mm in diameter.
My brother used a marker to on the hard plastic casing because the image or video rolls, but i like that i can do different effects, like the Dutch angle, pan, tilt.
The led lights are not strong, if is not enough light in the room, but it helps a little by increasing the brightness or contrast in its installed sofware, and also the lenght of the cable could be shorter, like 2.5 m, to avoid holding the extra cable with you. The casins gets warm after a couple of minutes, but i can holdit by the cable.
You can go in small places with the cable or in liquids (i didn't try it yet and i was thinking what swiming in coffe looks like).
You can take pictures at 320x240, 640x480, 800x600, 1024x768, 1280x720, 1600x1200 resolution and videos at 320x240, 640x480, 800x600, 1024x768, 1280x720, 1600x1200 resolution, but increasing the picture or video resolution beyond 800x600 blurs the image as it is zooms in, but the frame goes down.
I will post some pictures for comparison and see if i can make the sound register properly and why the camera controls are grey out and unusable.