For makers, there's some things to really like about this camera module. Most obviously, it takes good pictures -- much better than ones using any other commonly available hackable module we've found.
As well as better pictures, you can take more of them. The HQ Camera module is capable of up to 120FPS video which means it can capture fast-moving events.
The lens mounting system means you can use a staggering range of different lenses. You'll see a small number of lenses at resellers at the moment, but there's already an ecosystem of C and CS lenses you can use. There's also a range of adaptors that can link into other types of camera mounts. If you've already got a selection of camera lenses, it's worth checking if there's an adaptor that can link them to the HQ camera module.
The two downsides to the new camera are size and cost. It's a much bigger and heavier beast than previous camera modules, so you'll need a beefier drone if you want to get this thing in the sky. At $50 (plus lenses), this is noticeably more expensive than other camera modules for the Pi, but for that you get noticeably more camera.
The products that excite us the most don't just make projects better, they make whole new classes of projects possible, and this is one such product. Yes, you can make better wildlife, astronomy and security cameras with this, but additionally we suspect we'll soon be seeing a range of projects from creative makers that we haven't even imagined yet thanks to this.