I had 28 mm, 55mm, and 135mm prime lenses for my film SLR. If I carried only one lens on a hike, it was the 28. For outdoor landscapes, the 28 did what I wanted. When I got the A75, I found the 35mm min eFL to be a disappointment for the big scenes. (This is all just my style and opinion. Others may reasonably differ.)
Ken Rockwell comments in his review (
http://www.kenrockwell.com/canon/sd800.htm)
If you do a lot of portraits or prefer the telephoto range, get the SD700. or newest SD850.
If you prefer wider angles, get the SD800.
(The SD700 has an eFL of 35-140mm.)
I agree, and since I use wide angles more than I use telephotos, I would favor a camera with the wide angle (<= 28mm) lens. Your choice.
I think the pixel race has gotten a bit out of hand (like the GHz race on computer CPUs...)--it isn't clear to me that the small and inexpensive lenses on P&S cameras have adequate resolution to justify them. And, of course, the smaller the pixel on the sensor, the noisier it is. I'm perfectly happy the with 3.2MP on my A75. A number of reviewers have commented that anything beyond 7 or 8 MP makes no sense on the P&S cameras.
As for manual controls... I have attempted to use them on my A75. They are sufficiently hard to use and the user feedback is sufficiently poor that they are, IMO, of little use except shooting a still-life with a tripod. Focus requires you to measure with a ruler, and dial it in on a menu. There is only an aperture range of about 3 stops, so you can't do much with it. I basically shoot everything in programmed auto (P) mode. I can usefully set the ISO and enable/disable the flash manually, but that is about it. Emotionally, yes I want the manual controls (I guess I'm just a frustrated SLR user when I have a P&S in my hands...), but practically, I don't use them.
I would prefer an A-line camera with the SD800 lens. Since Canon doesn't offer one, the SD800 IS might be the best for me. If I am willing to forgo the 28mm eFL, then I would probably choose the A-570 IS.
I would also submit that the IS (image stabilization) is worth having. It will enable you to shoot hand held in several stops less light than without. Ken Rockwell has a nice tutorial on IS:
http://www.kenrockwell.com/tech/image-stabilization.htm.
Doug