My brother and I want to making short videos. Our camcorder is very bad quality (especially in low lighting).

We don't want to spend over $500. What camera would you recommend us?

We want a good quality even in low lighting if possible.

gopro is more for shooting sport activities, we don't want that :S