Recommendation for a flying camera device
The on board cameras you ask about I have found to be sub-par in resolution, so I would focus on models you can attach a camera to. 

One of mine - the Parrot AR Drone 2 - I simply gaffer tape a gopro to - the obvious problem is any movement of the drone to cope with flight results in a camera shift - the onboard cameras have this issue too of course.  This can be stabilized out with good post-processing tools, but it's worth, budget allowing, to have a Gimbal for the camera.

Having used a Phantom 2 Vision system with a remote control for the Gimbal with video feedback, this was absolutely a winner for a film production, as the director I could watch each run, in high winds which occupied the pilot.  This requires quite a bit of gear - the camera signal broadcast to a monitor (for us over wifi), the control of the gimbal, and the control of the drone.  The positive of this system was the Gimbal and Drone control was centralised, so each didn't need their own battery, broadcast, and control systems.

So if you want smooth shots that don't "give away" it's taken by a flying machine and have a smooth flight quality, it really is worth having the camera separate on a Gimbal of some sort.  The advantage of the prebuilt systems for this (We take XYZ camera) is they've 1. worked in the weight of the camera for that drone, and 2. figured out it's best positioning in terms of a balanced flight and drag, and tested it for that.  Eg. If I gaffer tape my gopro in the wrong place, the drone stabilisation software fights it and the footage ends up shakey.  

Good luck, it's all very very fun!