My copy of the 24-70 I find fast to focus, not overly loud (doesn't bother me, but I've never owned a USM lens so...) and rarely hunts. I shoot indoors a lot, but I also typically have the ability to turn on lights if I want. I can't say what this would be like in a dark club etc.
But to answer your question AdamJL. A "Full Frame Lens" is one designed such that it's image circle is large enough to cover a standard 35mm film frame or a "Full Frame" sensor which is roughly the same size as standard 35mm film. The 300D, 350D, 400D, 10D, 20D and I think 30D all are "crop" cameras with APS-C sized sensors which are smaller than 35mm film. Lens manufacturers are making lenses that fit these cameras but if you put the lens on are "Full Frame" camera, you would not cover the entire sensor and the corners would be dark if not black. Canon's own EF-S lens line does this, but they have the added problem of only fitting a few cameras, the 10D does not work with EF-S lenses even though it has the smaller sesnor because the EF-S lenses have a special mount that the rear lens protrudes further into the camera and the mirror would hit it as it moves.
Do some searching and there are better more technical details of "Digital Only" lenses and EF-S lenses here. But that's why the 17-70 is "Digital Only", it does not cover a full 35mm size sensor or film, it is designed specifically to cover APS-C sized sensors.