I'm using a Sony HD Handycam HDR-CX440 along with a Sony VCT-R640 Lightweight Tripod. Been very happy with both, but will probably look for a 4K cam next year.
I will tell you that your video editing suite and your editing skills also play a big part in your end result.
Good luck with your videos and have fun!