i looked through this forum and noticed every talking about Canons being excellent, i have to second that!!!
I use a Canon T1i one of the few Canon SLR's with video taking capability's. Its a fantastic camera, i love it, takes amazing crisp clear photos! But i haven't used any other SLR so i dont have anything to compare it with. i also took a picture of the moon like that but completey handheld and i was suprised how much detail it had.
But for a point and shoot camera's thats a different story. Iv'e had many different brands, and all of them either sucked really bad or were way to expensive for the quality EXCEPT for my Canon Powershot, that thing was amazing and extremely low-priced. My brother bought one of the ultra slim Canons with the tiny lens that was the same price as the powershot and it sucked in low light, so he took it back and got the newer model powershot than i had, and he loves it, its by far the best point and shoot for the price and it takes the best photos ive seen of any point and shoot, its got excellent zoom, handles all light conditions great, takes super sharp photos with great contrast and also shows more vivid life like colors than most camera's, you know, like when you take a sunset photo and its really dull, it takes care of that pretty well. also takes amazing video, most other point and shoots really lack this! one bad thing about it though is it wont zoom while recording, but Canon took care of that on the latest Powershots. (after seeing my brothers photos, my friend also bought a powershot and his can zoom while recording)
So from my experience Canon is the way to go!!!
note: lens size makes the biggest difference in point and shoots, not resolution! ive had cameras that had way more megapixels than the powershot, and the photos were grainy and crappy, also those huge files will eat up your hard drive pretty quick!