A camcorder does not "fit between super zoom and DSLR" - a camcorder is a device to make home videos that can also take low quality photos.
A camcorder is better designed to shoot video than any still camera (easier to hold and use) but they usually have crappy optics (because video is low res anyway) and are generally bad at taking photos.
Also a camcorder does not shoot pro level video, pro video gear is expensive (so expensive it makes top of the line DSLR look cheap).
If you want a device that shoot both photos and videos and fits in your pocket get a point and shoot.
If you want image quality and control get a DSLR.
If you want something in the middle you can get a mirror less interchangeable lens camera.
If all you want is low quality video than a camcorder is just for you.
obviously I'm talking about consumer level camcorders here (point and shoot price range) , I don't think anyone will call a pro video camera a "camcorder"