At the end of the day, get any decent make camera, and make sure it has a long(ish) max exposure time - 15 seconds+ or better still a 'B' setting.
Don't get too hung up on the need to spend lots of wonga.
This picture:
Shows spungletrumpet using a 99p, Ebay bought, camera (a camera he produced some cracking shots with)
It was shot on a 12 year old, 2.1MP compact that I found in a bin, and that is held together with an elastoplast, a bolt, and a bit of metal I literally found in the gutter
These are from the same 'bin-find-freebie' camera...
Granted they don't match my DSLR - but for the price of some batteries and a plaster they are perfectly useable, and represent a camera that - whilst I'd hate to lose/break it - owes me nothing - so the day it does finally fall/drown/get lost/get stolen (actually, forget the last one - if you'd seen it, no-one would pinch it) or whatever - nothing lost
:
.