for flash over tape, I can highly recommend any of the three cameras in Canon's Vxia HF-xxx line. I have an HF-10 and it is great. You can probably get one for around 7-800 dollars. The newest one, the HF-11, has 32GB internal memory and records at 24mbps, but i think it is a bit over $1000. You can also get the HF-100, which is exactly the same as my HF-10, the only difference is that it does not have internalstorage so you MUST buy SDHC cards. I have 2 x 16GB class 6 cards, along with the 16GB internal stoarge. at the highest recording level I get 2 hours on each 16GB.
Editing is great with final cut (i use express), but im not sure what you'll be using. Low light is good, im sure the HF-11 will perform better but you can visit camcorderinfo.com (linked above) and you'll get a great review.
Either way, you wont be disappointed in the quality. My only two disappointments are that a) no firewire for live streaming like you can with a mini-DV camera (no flash camera to my knowledge has this either) and b) the battery only lasts 80 minutes, so i'll soon be purchasing the canon extended battery.
