Which inspection camera to use with my MacBook Air?

This question relates to inspection cameras also known as snake cameras, endoscopes, borescopes or fiberscopes.

I want to buy an inspection camera which sits at the end of a cable perhaps 2-3m in length. I want to plug it straight into the USB port of my MacBook Air running 10.8.5.

It should have an illuminated tip and reasonably good resolution so that I can inspect areas under floorboards and within cavity walls. A waterproof version for use within a drain would be a bonus. It does not have to be medical grade.

I have spent hours trawling the web trying to find a suitable device.

I see several cameras most which seem to originate from China which (a) are reviewed as having poor resolution and (b) require software installation from a Chinese CD. Neither fill me with great confidence.

Surely somewhere out there this is a device which is of reasonable quality and will plug-in to my MacBook Air and work without having to load unverified software. For the avoidance of doubt I don't mind paying for and loading software as long as it's from a trusted source.

All help much appreciated.