Well, any picture you take on this phone is....well it's obvious it's from a phone and not a camera. The video isn't much to shake a stick at either.
As far as Moment vs. Pre, I'd actually recommend taking a look at the pre. My Moment is more or less pissing me off to such an extent as to make me consider the Hero.
My issues this far with a few months use;
1. Radio lock outs. This is where the phone basically locks you out of making calls, browsing the web, or sending text messages, rendering the 'phone' useless. I get these on average 4 times a day now, even as bad as 9 occasionally.
2. Some touch screen glitches. My touch screen wigs out on me about three times a day, where it sees my 'finger' travel all across the screen in random spastic movements until I lift my actual finger off the screen.
3. Random restarts when the battery gets close to 20% or so. If you're doing anything aside from sending a text message or making a phone call when it hits 20%, stop drop and save your stuff. It's highly likely that it will lock up and reboot on it's own.
4. The screen is very nice, clear, colorful....indoors. Outside, unless you can cover it with your hand or something, it's next to un-readable. I'm not quite sure to this day as of why it's like this, but it's one major drawback.
5. WiFi issues. The WiFi is decent, but if you're going to download something with it on, good luck to you sir, you'll need it. You just can't do it, all the downloads hang up until you connect back to 3g/1x.
6. The camera takes god awfully long to activate. It takes a good 15-20 second for mine to open up, and even longer to switch over to video. It's not really practical for take-it-out use where you snap it on and just take a picture. I had to use mine because I was in a wreck a few days ago, and after restarting it to call 911 because my radio locked up, I had to sit and wait for the camera to open up to get pictures of all 4 cars damages and license plates. Never before have I felt such a burning desire to throw my phone into the street and watch, laughing as on-coming traffic annihilates my device.
My phone has pissed me off royally, nearly like this before, and many a times before as well.
In short, if you can deal with the issues, I say this is a decent phone right now. Not as far as great, just decent. I can't speak for the Pre, as I chose this over it. The Pre just feels downright cheap and flimsy.
-edit-
Wow, I typed all that out using Swype, and this! Dang, maybe an all touch screen experience aint half bad... meh, I just had an 'omg' moment, thought I'd share it with all of you lovely fellows.