Currently the best camera option I have is the raspberry pi camera. With a long enough exposure I can get actual images of the stars. It's only really sensitive enough for fireball type meteors however which isn't great.
I've tested with a DSLR, but its considerable overkill and the Pi has trouble processing the large images.
Facing these issues I searched ebay for an inexpensive low light USB camera and found the AR0130. Unfortunately, this camera is not as good as advertised and the images were of poor quality.
I think that a standard digital camera may be a good option and I'm going to start hunting through those.