There's a review here:
Nikon D3000 Review: 1. Introduction: Digital Photography Review
If you're looking at that, I recommend the D5000. The CMOS sensor exceeds the CCD, especially in low light. Price is a little more, though.
Nikon D5000 Review: 1. Introduction: Digital Photography Review
All that said, If you're looking to experiment with manual modes, the Canon G11 is an excellent choice. I got one over the holidays. It has all the control I'm accustomed to with the DSLR. It does macro fairly well. Color is fantastic and it has a bunch of different auto modes if you want to step down from that "next step" occasionally. And it makes excellent photos.
Canon PowerShot G11 Review: 1. Introduction: Digital Photography Review
FWIW, I started out with an entry level DSLR, a Nikon D50. A few years later, I got a D300. If you decide you like the control, there's a good chance you'll end up buying another DSLR above the entry level machine as well. I can tell you that the D300 is far superior to the D50. Much more control, better sensor, etc.