Not Sony Based, but there's a firmware hack that allows to run scripts
If you can compromise on something between a DSLR and point-and-shoot-compact, I can highly recommend Sony's H-series. I have a H9 (now superseded by H11) and it really is good. Great quality, and you just can't beat the 12x zoom that a larger body gives you.
Has an "automatic" mode for point-and-shoot, turn the dial to adjust separately or together the apeture/ISO/shutter/EV. Uses memory stick pro-duo, not sure if that's the type of memory stick you have, or if you have the old memory sticks.
Only problem is there is no remote / external port (that I can find - let me know if anyone knows about it), so I don't think you can trigger the camera in any way besides pushing the button on the camera body.
The old camera was a W80, and before that a W60. It's been a very bad track record as far as how long these cameras last too.
Really... we've also got a W80 and that has been an excellent camera - no troubles over the year and a half or so that we have had it. "Beach" mode is funny though - everything comes out blue, even sand.
I just came around this.http://www.fleurey.com/weblogs/franck/index.php?2007/03/11/127-telecommande-ir-pour-nikon-d70-fabricationIt's in french, but maybe it can help you. It's an IR remote for the Nikon D70.