I need a good review and comparison to the best there is right now?
Clicking the mark as good answer button helps us highlight the best answers.
There are cameras with even larger sensors than the full frame sensor DSLRs from Nikon and Canon; but they tend to be beasts (really large and heavy) and are very much pro cameras. Check out Mamiya and Hasselblad if massive sensors turn your crank.
As to what constitutes "best" . . . that really depends on your needs and budget. You don't need a DSLR to take great photos or shoot great video. As is the case with audio gear, the question is what you are willing to bear to improve quality. There are certainly situations where portability or a more discrete camera will get you a shot that you might not get encumbered by a DSLR.
This video is from one of the best camera review sites out there: www.youtube.com/user/DigitalRevCom#p/search/1/3D1p...
Right now, the EOS 5D Mark II is one of the best cameras in the world, rivaled only by the Nikon D700. However, the EOS-1Ds is probably the best dSLR even though it's very expensive (reviews.cnet.com/best-professional-dslr-cameras/). Canon is going to be releasing the EOS-1Dx (www.usatoday.com/tech/products/story/2011-11-05/ca...) which is undoubtedly going to be the top dog on the market.
I think the video review was good as well and help me understand a few things. Saving to buy one someday hopefully, hence the interest. I have a friend who owns the Nikon D700 and the shots he produced with it were awesome. He was telling me it was the best and i think you just confirmed that.
Does it mean though that the best cameras are dSLR and how is that different from the other camera technologies if you can help?