The Canon A95 is an excellent choice except it might be a bit more than you want. It has all the manual override controls. Of course you can set it to Auto and forget about manual controls.
The Casio EX-Z4U is the American model and does not have movie mode if that is important to you. The European model (EX-Z4) does have movie mode. There has been one update to the firmware in this camera since it was first introduced, so make sure you get the latest model with the new firmware.
The W1 takes excellent photos in the daytime.
People complain about flash photos and photos taken in low light. They often come out blurred due to the camera selecting too slow of a shutter speed.
Two more cameras you should look into are the:
Canon S410
Canon S500
...
..
.
Please suggest which one to buy among...
Canon A95 vs Sony W1 vs Casio Exilim EX-Z4 OR any other good camera
Picture quality is the primary criteria, secondary criretia is...i don;t have to do many manual adjustment while taking pictures & third one is compactness.
THanks for any suggestion(s) in advance!
-Payal

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic