Think of Super 8 as the home movie format your grandparents used
Camcorder as the one your parents used
and 16mm film the one an indie filmmaker might recommend

The most detail will be gathered through 16mm which is a bigger format than the small 8mm of Super 8 and camcorder.

Camcorder is an analog tape format that will give us pixelation, while formats like Super 8 film and 16mm will give us grain.

Super 8 film has a softer, ethereal feel while 16mm film has a sharper and more detailed image.