Depends on your application mate. Personally, I have a Sony DSCP-1 3.3 megapixel, which is a top unit IMO, although I must admit, I don't use the really high quality resolutions all that often (unless it's for a detailed car / engine shot - hehe). Normally, I use the lowest 640 X 480, as it's smaller in filesize, and better for emailing to ppl etc. Still, I guess it depends on what you want it for. Again, as shorsfall has mentioned, depends if you print them too. Sony cybershots are good compact units, but I've heard very good things about Canon and the Nikon coolpix range. Also depends on your budget too.
Wagons are rarer ;-)