I want a little camera to put through holes in floorboards, to check for
leaking pipes and the like. USB, attached to the laptop should do the
trick, but I have tried one before and it was pretty crappy with a very
small depth of focus.

Can anyone recommend one that actually works well? Preferably not too
expensive.