Canon Sd 940 is. Good or Bad?

I have been a loyal canon user since my first point and shoot.  I love the ease of a pocket camera.  I still use my DSLR for getting the perfect settings.  However, the small canons have been my go to camera since our little whirlwind came to town.  He is fast, and I need a camera that is just as fast.  When I first got the sd940is I really liked it, except sometimes it made the indoor pictures look really strange when on the auto setting.  One of the selling points of the camera was that in the auto mode it would select the scene setting for you.  Which sounds good when it is on paper, but it just doesn't perform as other canon elphs that we have owned.  This is the third one in a 10 year stretch of fabulous picture taking.  I don't like the sd940 now though.  It is slow, and the zoom just starts zooming when I depress the shutter button.  The indoor pictures are extremely blurry, unless we are using the flash.  I love the look of natural light, but the camera just won't let that happen indoors.  Outside it does a decent job, on a cloudless day and when the sun is shining bright.  I need something that will be more reliable.   I am on the hunt (again) for a point and shoot that can do everything.  Any suggestions?  I need one that has video capability (one of the reasons we choose the sd940).  We have to have video of our munchkin.  I write this because I need some input, and if there is anyone out there, please tell me what you think.
Thanks.

LensBaby Composer

I bought the LensBaby Composer the other day. It is an amazing lens for my Sony A-100. I got it the other day and have finally had a few minutes to take it out and experiment. I was having trouble getting it to work with my camera, but I just changed the settings to shutter to fire even when lens is not attached. (Go to menu second screen under shutter) The alpha was just not recognizing that a lens was attached. The Lensbaby is a fully manual selective focus lens. It is so fun to play around and get different effects.
I took a few shots of some planes at the museum, I really like what I got. I can't wait to take some portraits with it to see what sort of fun effects will emerge. As with anything new, it takes time to learn the tricks. This is no exact science. It is great to get out and just try something new. The lighting seems a little tricky to me, but I am sure with some practice I will be able to get it right.




If any of you photographers out there have any tips to share about the LensBaby Composer, I would love to hear them. I also love to browse the LensBaby photos on Flickr. If you have some to share leave me a comment!