Suggest you go to
http://www.dpreview.com and use the Buying Guide. Set the parameters for 3 megs and compact, see what pops out. Follow up by reading the reviews.
Most likely anyone posting here with a suggestion of "THE Best" will tell you only about the one 3 meg camera they've shot. Few people have had experience with a wide range of cameras except for the professional reviewers.