I've recently seen a "making-of" of a music video which featured quite impressive aerial shots, and they used a remote-controlled quadcopter with a gyro-stabilized cam. So for this specific segment, it will be hard to compete against this with a full-sized chopper.
We'll see UAV innovation primarily in the military sector, where cost-effectiveness is not always a primary concern. However, this will eventually trickle over to the civilian sector in one form or another. Civilian UAV applications are conceivable if they are commercially viable (Operating an unmanned K-Max is probably not cheaper than one with a pilot) and do not involve passenger transport (e.g. powerline patrol).
But before we'll see that, some legal issues are yet to be solved (e.g. "see and avoid" principle and liability questions).