Super-8, 16mm & 35mm are all use film to record images. (The 8, 16 & 35 is the measurement, in millimeters, of each frame of film)
The rest are video, recorded onto (usually) magnetic tape, though some of the more recent cameras record onto hard-drives or flash-drives.
There's all kinds of variables for video (which also affects film, too, as that is almost always transferred to video at some point... editing, broadcast, whatever)
Mini-DV is still fairly common (using either 640x480 (tv-sized) or 720x480 (widescreen-sized)
HD has a tonne of different standards (very annoying... it ain't standard!), but has much greater resolution than plain mini-DV.
DV (by itself) is just a general term, encompassing any camera recording digitally - so ya got:
Mini-DV - usually tape.
HD - could be tape or digital drive
HDV - could be tape or digital drive
BetaSP & Digicam (magnetic tape)
8mm & Hi-8 (not film - some of the first mass-consumer camcorders, using an 8mm magnetic tape cassette)
Digital-8 (funky Sony format that bridged a gap between Hi-8 and mini-DV)
You also had VHS, S-VHS, and a host of other formats. Each with their own specs, not compatable with each other. All kinds of crazy differences with lines of resolution, aspect ratios, and more.
Your XL-2 is mini-DV (but a rather nice one)
35mm is used for major motion pictures?
If they're shooting film it would be a good bet, sure. Some use 16mm, and blow it up to 35mm later if needed. A few use 70mm.
More & more are shooting digital, though.
Btw, there's a really awesome flick that was shot on Super-8 (and a pinch of 8mm digital).
"The Saddest Music in the World"
No reason for mentioning that. I just like it.