If this stellar production was achieved single-handedly with a cheapo point and shoot, I'd feel like a real loser
In photography, the camera's capability is important up to a point. I mean you're not going to be doing 30 minute astrophoto's or stopping dancer motion in a moderately lit theatre at 5 frames per second with a generic point and shoot.
Beyond that it's all about the person behind the camera. Knowing where to aim and the shooting angle.
Based on the video, I'd guess:
Drive mode: Continuous shooting (shutter burst at 6-10 frames per second max and not for long periods of time either)
(Side note: A cabled remote shutter release would go a long way in allowing for camera positioning in a one handed environment like that. DSLR's are way too expensive to be dropping due to awkward holding positions and trying to hit the shutter release on the camera)
Shooting mode: Program AE (translation: he had a very expensive point and shoot camera) There is way too much going on to be fiddling with settings between every shot.
Auto focus.
Looks like a generic 18-55mm lens or thereabouts though there are several lenses that could do similar stuff.
A camera operator is essential. A solo rider can't do all that..well, at least not for long before crash testing the camera and/or himself.
A deliberate lack of precise camera control (settings and camera position/orientation) is essential for the overall effect.
A reasonable amount post processing to select which sequences and putting them together and inserting music.
Great magical levels of difficulty? No.
Dirt simple by going out without any plan in mind and not knowing what makes a good photo? No.
That's very well done though. I'll have to try something similar sometime if I can find a good camera operat...nevermind, I know someone who would be perfect to do the shooting.