I recently bought my Kindle Fire and I really enjoy it. For the price, it's definitely worth the money. Now, the app store for the Fire is limited at the moment. But if you root your device (similar to jailbreaking an iPhone), you can access the Android market with all the apps.
The Nook Tablet is also a nice tablet as well. I ended up getting a Kindle Fire due to the price, size, and video content through Amazon Prime. But after adding the Android Market, it's even better when I first opened the box.
The reviews on CNET helps along with some of the thorough comments from people who have bought the Kindle Fire through Amazon. Many people break down the pros, cons, etc.