CHDK is indeed a great way to make your Canon Powershot point-and-shoot intelligent. Back before drones, I used it to do timelapse videos and kite aerial photography with my A590. It loads in your Lua script from the SD card on boot, and doesn't make any permanent changes to the camera. So it's basically like loading in an app to supplement the operating system. And it will react very quickly to any change in the scene - great for fireworks, lightning strikes, birds about to land, etc.