That $500 DSLR can definitely do some impressive work, but the issue is in how it processes the images.
A DSLR will read the sensor progressively, from top to bottom. So if an image changes from the top of the frame to the bottom (if the camera pans or an object moves horizontally) the top is recorded slightly before the bottom, leading to a "tilting" effect. This would be really noticeable if you were to follow someone around with a steadicam, or had objects moving across the screen with any real speed.
When I watch short amateur films on Youtube this effect can ruin the whole experience for me, since I can't stop noticing it. However, a shot of a rock show (crowd or stage) would likely be busy enough to make the effect unnoticeable. There are probably algorithms that fix it too, especially if the film is shot at a higher resolution than is being output (to allow adjustments at the edges of frame).