All good things come in small packages! As for the Nikon D3100!

Nikon D3100 14.2MP Digital SLR Camera with 18-55mm f/3.5-5.6 AF-S DX VR Nikkor Zoom Lens
Bravo! The long wait is over! Nikon had to wait so long for new models (D3100 and D7000) and was when we began to wonder if Nikon will never answer that soon T2i Canon 7D and 60D), published two excellent cameras - D3100 and D7000. Let us focus on the D3100, okay?

So I finally had the chance to get their hands on a digital SLR today's Best Buy. I am not a professional by any means, but I have used many digital SLRs, including Canon (40D, T2i, XSi) and Nikon (D90, D5000). When I took the camera for the first time, my first reaction was: "Wow - this is not so small and light that I was not aware of any technical details - I already knew, but still shocked at how small and light I felt when I held in my hands!. Then I thought, the decision is not very comfortable, but I was wrong and that the task of keeping the camera is excellent - thanks to the clever design of Nikon and grip size and style is very similar to D3000, but has more goodies later.. So the initial wow factor here, soon moved to focus on functionality and features.

I just started using this product if you will be more updates, but in the meantime, my initial assessment of this unit - I'm impressed! This is a piece of equipment that can certainly compete with the best in its class (Canon T1i, T2i, Nikon D5000). See detailed comments on dpreview and cameralabs (short) (Com.) - should be soon if not already there.

I love this camera because it:
+ has enough mega pixels for my needs (14.2).
+ captures crystal clear images (thanks to EXPEED2 processor & the CMOS sensor, the sensor is slightly smaller than the one used in D7000).
+ offers 1080p (HD) recording, AF subject tracking is awesome (10 min max is fine with me; it records outstanding videos even in low light and to me that's big).
+ offers ISO from 100-3200 (D90 starts at 200), it can go higher but I really don't think why I would need anything above that.
+ is small & light weight yet has good grip, easy to carry around in hands or neck.
+ supports SDXC cards on top of SD and SDHC - now that's nice.
+ (25-Sep-2010): has buttons that are well organized especially the video recording mode with a lever so you cannot mistakenly activate recording. That video recording lever once unlocked, gets locked in 30 seconds if you do not record and the countdown begins as soon as you unlock the lever. Also you can record video while you're in any dial (imaging) mode (Auto, P, A, S, M, and so on) where as in Canon T2i, etc. you have to move the camera dial to movie mode. So this is a great convenience - you can jump between taking pictures and recording videos with a simple unlocking of the lever. Additionally, you can be in a preferred dial (imaging) mode (Auto, P, A, S, M, and so on) and change the release mode to Single, Continuous, Self-timer or Quiet mode (this is located right underneath the main dial) - another great convenient feature.
+ (04-Oct-2010): In-body photo and movie retouch menu. This is great as we don't need any special software to apply certain touches. I love it.

Could have been even better if:
- it had the bracketing option (not too much to expect at this price point level but oh well I don't use that much but for some people this could be a big plus).
- grid lines were available (I miss them in both in live view and in the view finder).
- Active D Lighting was not limited to just ON or OFF (either you have it or not at all, instead of low, medium, high, etc.). Don't get me wrong the ON just worked fine (better than Canon T2i) but I can't compare with all other modes.

Recommendations (optional accessories):
* In my personal order of importance - your preference may differ. *
1. Nikon UC-E4 USB Cable - not included. (~$6)
2. UV filter - a must for protecting your lens against accidental damage. (~10$)
3. Carrying case is a must to protect your investment. There are many cases to choose from and it's up to you to decide but I suggest getting something like Lowepro SlingShot 102 AW (all weather proof carrying case) so if it rains, you can pull out the weather guard and cover it up. ($90)
4. Additional rechargeable Lithium Ion EN-EL14 battery so you never run out the juice when you're traveling and do not want to miss capturing a moment for good. (~$35)
5. SB-600 Speedlight. Those who have used speed lights would know what difference it can make to an image with adjustments you can make to light for an image. (~$225)
6. 18-55 VR lens has its limitations so if you have extra $$$s, buy body only (if that even is an option) and get yourself a 18-105 VR lens. But at that point, you may want to consider D90 which still is a good camera and offers many more controls. (~$325 to $350)

Overall: I give this camera 5 stars because it takes great pictures in almost any conditions (or low light) and that is exactly what I wanted to make this device for me. Period. I have to commend Canon mega pixels do not enter the race (read marketing). Instead, in their view, the photographer in mind, and strives to provide better image quality. Kudos to Nikon for having the courage.

Read more detail on Nikon D3100 14.2MP Digital SLR Camera