I was lucky with the SD 300 because I recently bought a laptop that takes the SD cards but not the compact flash cards - so I ended up with the right camera.
I don't think you can go too wrong with Canon - I chose the SD 300 because it's very small and even in the case can fit in my inside coat pocket. Basically, I figured I would use it much more if it were very small. The body is built very well and the LCD is large and very pleasing. It's also very fast and very easy to use. It also has a better video mode than the A95 and a newer digic processor downside is it's a rechargeable battery so you need a back-up and you have to get it from Canon.
It has less manual control and you pay for the compact size but so far it's got that cool James Bond aspect to it. Cool. Takes very good pictures better than I would expect from a very small camera.