In my testing with the
sx230hs, I got an average of 150ms from detection to picture. I used a motion detect program and did many dozens of tests. Fastest was .099 ms slowest was closer to 250ms.
My problem was taking pictures in real life. I was taking pictures of some friends and it took between 1-2.5 seconds to cycle from 1 picture taken to the next. Way too slow for my needs. And that was with and without chdk loaded. I eventually returned my camera and got a Canon t2i slr instead.
Magic lantern (based off chdk) is supported, so I still get the motion detection etc.
Good luck with getting chdk and scripts to work properly. The sx230 really failed me in almost every way. Not a chdk problem, just the camera itself wasn't that great.