Hi there, most cameras ship with their own downloading software that generally doesn't work with macs, the good news is that you dont need it. Macs will by and large just swallow up your footage into programmes like imovie. (The majority of modern domestic cameras shoot AVCHD which will be fine into a mac and imovie.) So what sort of money do you want to spend is the big question? panasonic do some good video camcorders recording onto SD cards rather than tape, (I got a panasonic HD SD60 a few years ago for about £350 and its fine for what it is)
alternatively if youve already got (or want) a proper stills camera, look at the canon 7D, 60D or 550D & a 300mm lens - they all take great looking video nowadays plus you get a good stills camera too.
main thing is budget really, but its good fun shopping!
cheers